{"text_format":"2","workbook":"xlsx","n_sheets":28,"sheets":["Dairy Wizard","Data entry","Operating costs","Capital costs","Options","Data entry (3)","Operating costs (3)","Capital costs (3)","Options (2)","Report","Data entry (4)","Livestock","Slurry report","Rainfall","Markers","Effect on profit","Data entry (2)","Operating costs (2)","Capital costs (2)","Cubicle v straw","New cubicle","Cubicle + slats","Scrapers","Flushing","Light","Sand","Mattress","Mat"],"not_rendered":{"charts":0,"images":169,"macros":1,"external_links":0,"defined_names":80,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dairy Wizard","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Parlour Wizard"]
["Data entry"]
["Farm name/reference"]
["Herd size"]
["Milk yield/cow"]
["Depreciation buildings",5]
["Depreciation plant",10]
["Interest rate",5]
["Electricity cost",10]
["Water cost",1]
["Labour cost",10]
["Tractor + man cost",25]

{"sheet":"Data entry","index":1,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Housing Data entry"]
[]
[]
["Planned investment",100000]
[]
["Cow number for new house",100]
["Annual yield/cow",7000]
["Housing period ",200,null,{"$f":"366-B8","v":166}]
["Period of heat stress",0]
["Depreciation buildings",{"$f":"'Dairy Wizard'!B6","v":5}]
["Depreciation machinery",{"$f":"'Dairy Wizard'!B7","v":10}]
["Interest rate",{"$f":"'Dairy Wizard'!B8","v":5}]
["Electricity cost",{"$f":"'Dairy Wizard'!B9","v":10}]
["Water cost",{"$f":"'Dairy Wizard'!B10","v":1}]
["Labour cost",{"$f":"'Dairy Wizard'!B11","v":10}]
["Tractor + man cost",{"$f":"'Dairy Wizard'!B12","v":25}]
["Straw cost",40]
[]
["Sand cost",15]
["Sawdust cost",50]
["Yield per cow in milk",25,"litres/day"]
["Butterfat price",1.5,"p/1%"]
["Milk price",18.5,"p/litre"]
["Milking diet cost",200,"p/cow/day"]
["Quota leasing price",0.1,"p/litre"]

{"sheet":"Operating costs","index":2,"n_rows":95,"n_cols":7,"rows_kept":95,"cut":false,"hidden":false,"merged":[[51,1,51,6]]}
["OPERATING COSTS"]
[]
[]
["BEDDING REQUIREMENTS"]
[]
["Straw unchopped yard",15,"kg/cow/day"]
["Straw chopped yard",10,"kg/cow/day"]
["Straw unchopped cubicle",7,"kg/cow/day"]
["Straw chopped cubicle",5,"kg/cow/day"]
["Straw chopped cubicle/mat",3,"kg/cow/day"]
["Sawdust cubicle/mat",1,"kg/cow/day"]
["Sand cubicle",14,"kg/cow/day"]
[]
["LABOUR REQUIREMENTS"]
[]
["STRAW YARD bedding","Mins./cow/day","Labour units"]
["Manual bedding",0.9,1]
["Tractor mounted",0.45,1]
["Overhead dispenser",0.3,1]
[]
["STRAW YARD cleaning","Mins./cow/day","Labour units","Note: 2 men; 1 tractor/1loader & 2 spreaders"]
["Yard cleaning",0.28000000000000003,2,"Every 4 weeks, 48t straw & 108t slurry (60% of 60l/day) with 2 men"]
[]
["CUBICLE bedding","Mins./cow/day","Labour units"]
["Straw manual",0.6,1]
["Straw tractor chopped",0.5,1]
["Sawdust manual",0.6,1]
["Sawdust dispenser",0.3,1]
["Sand manual",0.4,1,"3 times/week"]
["Sand dispenser",0.13,1,"3 times/week"]
[]
["CUBICLE scraping","Mins./cow/day","Labour units"]
["Scraping",0.6,1,"2 times/day. Storage adjacent to cubicles"]
[]
["Scraper system"]
["Maintenance % of capital",2]
["Electricity kW/cow/day",0.18]
[]
["Flush system"]
["Maintenance % of capital",0]
["Water/cow/day",0,"cubic metres"]
["Electricity kW/cow/day",0]
[]
["HS Ventilation system"]
["Maintenance % of capital",2]
["Electricity kW/cow/day",1.6]
["HVLS Ventilation system"]
["Maintenance % of capital",2]
["Electricity kW/cow/day",0.14000000000000001]
[]
[]
["THI","           Relative humidity %"]
["Temp",0,20,40,60,80,100]
[22,{"$nulls":5},72]
[24,null,null,null,72,73,75]
[26,null,null,72,74,77,79]
[28,null,72,74,78,82,84]
[30,null,74,77,80,83,86]
[32,72,76,79,83,86,90]
[34,74,78,82,86,90,94]
[36,76,80,85,90,94,98]
[38,78,83,87,92,97,99]
["Milk yield loss = 3%/1 THI (>73)"]
[]
["Supplemental light"]
["Yield increase",8,"%"]
["Feed intake increase",6,"%"]
["Decrease in BF%",0.16,"%"]
["Maintenance % of capital",2]
["Electricity use Kw/cow/day",0.5]
[]
["Remote oestrus detection"]
["£/cow/annum",50,"tbc"]
[]
[]
["Culling rate","%",null,"Cull cost","£/cow"]
["Straw",28,null,"Heifer",1750]
["Concrete",30]
["Mattress",28,null,"Cull",400]
["Mat",28,null,"Net",{"$f":"E77-E79","v":1350}]
["Sand",26]
[]
["Lameness rate","%",null,"Lameness cost","£/cow"]
["Straw",25,null,"Treatment cost",246,"Esselmont & Kossabati, 1997"]
["Concrete",28]
["Mattress",24]
["Mat",24]
["Sand",11]
[]
["Mastitis rate","qtr/100 cows/yr",null,"Mastitis cost","£/cow/qtr"]
["Straw",35,null,"Cost",183,"Esselmont & Kossabati, 1997"]
["Concrete",30]
["Mattress",25]
["Mat",25]
["Sand",20]

{"sheet":"Capital costs","index":3,"n_rows":64,"n_cols":5,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["CAPITAL COSTS"]
[]
[]
[]
["Housing only","Cost £/sq.metre","Sq.metre/cow","£/cow"]
["Straw yard",125,10.5,{"$f":"B6*C6","v":1312.5}]
["Kennel 2 row",95,4.5999999999999996,{"$f":"(B7*C7)-50","v":386.99999999999994},"Excludes concrete base for cubicle - select below"]
["Cubicle 2 row excl. bed",175,4.5999999999999996,804.99999999999989,"Excludes concrete base for cubicle - select below"]
["Cubicle 2 row with slats",355,4.5999999999999996,1632.9999999999998,"Excludes concrete base for cubicle - select below"]
["Kennel 6 row",95,5.2,{"$f":"(B10*C10)-50","v":444},"Excludes concrete base for cubicle - select below"]
["Cubicle 6 row  excl. bed",143,5.2,743.6,"Excludes concrete base for cubicle - select below"]
["Cubicle 6 row with slats",355,5.2,1846,"Excludes concrete base for cubicle - select below"]
[]
["Housing & feeding","Cost £/sq.metre","Sq.metre/cow","£/cow"]
["Straw yard",104,12.2,{"$f":"B15*C15","v":1268.8}]
["Kennel 2 row",95,8.9,{"$f":"(B16*C16)-50","v":795.5},"Excludes concrete base for cubicle - select below"]
["Cubicle 4 row",126,8.9,1121.4000000000001,"Excludes concrete base for cubicle - select below"]
["Cubicle 4 row with slats",355,8.9,3159.5,"Excludes concrete base for cubicle - select below"]
["Kennel 6 row",95,7.8,{"$f":"(B19*C19)-50","v":691},"Excludes concrete base for cubicle - select below"]
["Cubicle 6 row",130,7.8,1014,"Excludes concrete base for cubicle - select below"]
["Cubicle 6 row with slats",355,7.8,2769,"Excludes concrete base for cubicle - select below"]
[]
["Slurry store",null,null,"£/cow","Based on 10 cubic metres/cow for 180 days"]
["Storage",32,15,{"$f":"B24*C24","v":480},"Based on 150 cow cost >1500 cubic metres"]
["Reception pit",null,null,22,"Based on £3250 cost for 150 cows"]
["Pump",null,null,27,"Based on £4000 cost for 150 cows"]
["TOTAL",null,null,{"$f":"SUM(D24:D26)","v":529}]
[]
["Scraper system",null,null,"£/cow"]
["Total installation",null,null,66,"Based on 200 cow unit, 4 passage of 40 metre length"]
[]
["Cubicle beds",null,null,"£/cow"]
["Cubicle division",null,null,60,"Super comfort type included in building cost for cubicle options"]
["Concrete ",null,null,55,"Cubicle base not included in the building cost"]
["Mat + concrete",null,null,85,"Mat £30 + £55 concrete"]
["Mattress + concrete",null,null,115,"Mattress £60 + £55 concrete"]
["Sand & concrete",null,null,65,"Initial filling of sand £15/cow, but offset by saving in concrete for bed"]
["Water beds",null,null,165,"Bed £110 + £55 concrete"]
[]
["Ventilation",null,null,"£/cow"]
["High Speed Cooling fans",null,null,150,"36 fans for 132 cows @ £550/fan"]
["High Volume Low Speed fan",null,null,250,"6 fans for 132 cows @ £5500/fan"]
["Side wall curtain - auto",null,null,55,"Based on 200 cows, 60m long building both sides. Includes climate control"]
["Side wall curtain - manual",null,null,44,"Based on 200 cows, 60m long building both sides"]
["Insulated roof sheet",null,null,0,"per sq.metre"]
[]
["Lighting",null,null,"£/cow"]
["Total installation",null,null,45,"From Farm Energy Centre 2001 inflated to 2010."]
[]
["Flush washing",null,null,"£/cow"]
["Slurry separator",null,null,0,"Based on £25,000 cost for 200 cows"]
["Flush system",null,null,0,"Based on £25,000 cost for 200 cows"]
["Storage tanks"]
["TOTAL",null,null,{"$f":"D51+D52+D53","v":0}]
[]
["Remote oestrus detection",null,null,"£/cow"]
["Installation",null,null,0,"tbc"]
[]
["Machinery","£"]
["Straw chopper - tractor mounted",2750]
["Sand dispenser",3850]
["Sawdust dispenser",2200]
["Straw spreader",6600]
["Straw overhead dispenser",20000]

{"sheet":"Options","index":4,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"NEW HOUSING OPTIONS"]
[]
[]
[]
[]
[null,"Bedding Method"]
[{"$nulls":8},"If ticked then brings in slurry cost below"]
[]
[{"$nulls":8},"Milk sales/annum",null,{"$f":"'Data entry'!B6*'Data entry'!B7","v":700000}]
[null,"Building options",null,null,"                     Operating     costs      £/annum"]
[null,null,"Cost £/cow","£ total","Interest","Depreciation","Bedding","Labour","Other","Total","p/litre"]
[null,null,{"$f":"IF(Markers!$A$7=TRUE,IF(Markers!$A$2=TRUE,'Capital costs'!D6,'Capital costs'!D15),\"\")","v":""},{"$f":"IF(Markers!$A$7=TRUE,IF(AND(Markers!$A$38=TRUE,Markers!$A$34=1),'Capital costs'!B64,IF(AND(Markers!$A$37=TRUE,Markers!$A$34=1),'Capital costs'!B63,0))+'Data entry'!$B$6*C12,\"\")","v":""},{"$f":"IF(Markers!$A$7=TRUE,'Data entry'!$B$12/100*D12,\"\")","v":""},{"$f":"IF(Markers!$A$7=TRUE,'Data entry'!$B$10/100*('Data entry'!$B$6*C12)+(D12-('Data entry'!$B$6*C12))*'Data entry'!$B$11/100,\"\")","v":""},{"$f":"IF(Markers!$A$7=TRUE,housing_days*'Data entry'!B17*IF(Markers!$A$34=2,'Operating costs'!B7/1000,'Operating costs'!B6/1000),\"\")","v":""},{"$f":"IF(Markers!$A$7=TRUE,((housing_days*IF(Markers!$A$35=TRUE,labour*'Operating costs'!$B$17,IF(OR(Markers!$A$36=TRUE,Markers!$A$37=TRUE),LabourR*'Operating costs'!$B$18,LabourR*'Operating costs'!$B$19)))+(housing_days*'Operating costs'!$B$22*'Data entry'!$B$16))/60,\"\")","v":""},null,{"$f":"SUM(E12:I12)","v":0},{"$f":"J12/$K$9*100","v":0}]
[null,null,{"$f":"IF(Markers!$A$8=TRUE,IF(Markers!$A$2=TRUE,'Capital costs'!D7,'Capital costs'!D16),\"\")","v":""},{"$f":"IF(Markers!$A$8=TRUE,'Data entry'!$B$6*C13+IF(AND(Markers!$A$38=TRUE,Markers!$A$34=4),'Capital costs'!$B$62,0),\"\")","v":""},{"$f":"IF(Markers!$A$8=TRUE,'Data entry'!$B$12/100*D13,\"\")","v":""},{"$f":"IF(Markers!$A$8=TRUE,'Data entry'!$B$10/100*D13,\"\")","v":""},null,null,null,0,0]
[null,null,{"$f":"IF(Markers!$C$8=TRUE,IF(Markers!$A$2=TRUE,'Capital costs'!D10,'Capital costs'!D19),\"\")","v":""},{"$f":"IF(Markers!$C$8=TRUE,'Data entry'!$B$6*C14,\"\")","v":""},{"$f":"IF(Markers!$C$8=TRUE,'Data entry'!$B$12/100*D14,\"\")","v":""},{"$f":"IF(Markers!$C$8=TRUE,'Data entry'!$B$10/100*D14,\"\")","v":""},null,null,null,{"$f":"SUM(E14:I14)","v":0},0]
[null,null,{"$f":"IF(Markers!$A$9=TRUE,IF(Markers!$A$2=TRUE,'Capital costs'!D8,'Capital costs'!D17),\"\")","v":""},{"$f":"IF(Markers!$A$9=TRUE,'Data entry'!$B$6*C15,\"\")","v":""},{"$f":"IF(Markers!$A$9=TRUE,'Data entry'!$B$12/100*D15,\"\")","v":""},{"$f":"IF(Markers!$A$9=TRUE,'Data entry'!$B$10/100*D15,\"\")","v":""},null,null,null,0,0]
[null,null,{"$f":"IF(Markers!$A$10=TRUE,IF(Markers!$A$2=TRUE,'Capital costs'!D11,'Capital costs'!D20),\"\")","v":743.6},{"$f":"IF(Markers!$A$10=TRUE,'Data entry'!$B$6*C16,\"\")","v":74360},{"$f":"IF(Markers!$A$10=TRUE,'Data entry'!$B$12/100*D16,\"\")","v":3718},{"$f":"IF(Markers!$A$10=TRUE,'Data entry'!$B$10/100*D16,\"\")","v":3718},null,null,null,7436,1.0622857142857143]
[null,null,{"$f":"IF(Markers!$A$11=TRUE,IF(Markers!$A$2=TRUE,'Capital costs'!D9,'Capital costs'!D18),\"\")","v":""},{"$f":"IF(Markers!$A$11=TRUE,'Data entry'!$B$6*C17,\"\")","v":""},{"$f":"IF(Markers!$A$11=TRUE,'Data entry'!$B$12/100*D17,\"\")","v":""},{"$f":"IF(Markers!$A$11=TRUE,'Data entry'!$B$10/100*D17,\"\")","v":""},null,null,null,0,0]
[null,null,{"$f":"IF(Markers!$C$11=TRUE,IF(Markers!$A$2=TRUE,'Capital costs'!D12,'Capital costs'!D21),\"\")","v":""},{"$f":"IF(Markers!$C$11=TRUE,'Data entry'!$B$6*C18,\"\")","v":""},{"$f":"IF(Markers!$C$11=TRUE,'Data entry'!$B$12/100*D18,\"\")","v":""},{"$f":"IF(Markers!$C$11=TRUE,'Data entry'!$B$10/100*D18,\"\")","v":""},null,null,null,{"$f":"SUM(E18:I18)","v":0},0]
[null,"      Slurry System",{"$f":"IF(Markers!$A$4=TRUE,'Capital costs'!D27,\"\")","v":529},{"$f":"IF(Markers!$A$4=TRUE,'Data entry'!$B$6*C19,\"\")","v":52900},{"$f":"IF(Markers!$A$4=TRUE,'Data entry'!$B$12/100*D19,\"\")","v":2645},{"$f":"IF(Markers!$A$4=TRUE,'Data entry'!$B$10/100*D19,\"\")","v":2645},null,null,null,5290,0.75571428571428567]
[]
[null,"Cubicle bed options"]
[null,null,{"$f":"IF(Markers!$A$7=FALSE,IF(Markers!$A$15=TRUE,'Capital costs'!D34,\"\"),\"\")","v":55},{"$f":"IF(Markers!$A$7=FALSE,IF(Markers!$A$15=TRUE,IF(AND(Markers!$A$36=TRUE,Markers!$A$34=2),'Capital costs'!$B$60,IF(AND(Markers!$A$37=TRUE,Markers!$A$34=1),'Capital costs'!$B$63,IF(AND(Markers!$A$38=TRUE,Markers!$A$34=1),'Capital costs'!$B$64,IF(AND(Markers!$A$38=TRUE,Markers!$A$34=4),'Capital costs'!$B$62))))+'Data entry'!$B$6*C22,\"\"),\"\")","v":8250},{"$f":"IF(Markers!$A$7=FALSE,IF(Markers!$A$15=TRUE,'Data entry'!$B$12/100*D22,\"\"),\"\")","v":412.5},{"$f":"IF(Markers!$A$7=FALSE,IF(Markers!$A$15=TRUE,'Data entry'!$B$10/100*('Data entry'!$B$6*C22)+((D22-('Data entry'!$B$6*C22))*'Data entry'!$B$11/100),\"\"),\"\")","v":550},{"$f":"IF(Markers!$A$7=FALSE,IF(Markers!$A$15=TRUE,housing_days*IF(Markers!$A$34=1,'Operating costs'!$B$8/1000*'Data entry'!$B$17,IF(Markers!$A$34=2,'Operating costs'!$B$9/1000*'Data entry'!$B$17,IF(Markers!$A$34=4,'Operating costs'!$B$11/1000*'Data entry'!$B$20,\"\"))),\"\"),\"\")","v":4000},{"$f":"IF(Markers!$A$7=FALSE,IF(Markers!$A$15=TRUE,((housing_days*IF(Markers!$A$35=TRUE,labour*(IF(Markers!$A$34=1,manstraw,IF(Markers!$A$34=3,mansand,mansaw))),IF(OR(Markers!$A$36=TRUE,Markers!$A$37=TRUE),LabourR*(IF(Markers!$A$34=2,chopstraw,IF(Markers!$A$34=3,dispsand,dispsaw))),LabourR*IF(Markers!$A$34<>4,dispsand,dispsaw))))+(IF(OR(Markers!$A$24=TRUE,Markers!$A$31=TRUE),0,housing_days*scraping_charge)))/60,\"\"),\"\")","v":4166.666666666667},null,{"$f":"SUM(E22:I22)","v":9129.1666666666679},{"$f":"J22/$K$9*100","v":1.3041666666666669}]
[null,null,{"$f":"IF(Markers!$A$7=FALSE,IF(Markers!$A$16=TRUE,'Capital costs'!D35,\"\"),\"\")","v":""},{"$f":"IF(Markers!$A$7=FALSE,IF(Markers!$A$16=TRUE,IF(AND(Markers!$A$36=TRUE,Markers!$A$34=2),'Capital costs'!B60,IF(AND(Markers!$A$37=TRUE,Markers!$A$34=1),'Capital costs'!B63,IF(AND(Markers!$A$38=TRUE,Markers!$A$34=1),'Capital costs'!$B$64,IF(AND(Markers!$A$38=TRUE,Markers!$A$34=4),'Capital costs'!$B$62))))+'Data entry'!$B$6*C23,\"\"),\"\")","v":""},{"$f":"IF(Markers!$A$7=FALSE,IF(Markers!$A$16=TRUE,'Data entry'!$B$12/100*D23,\"\"),\"\")","v":""},{"$f":"IF(Markers!$A$7=FALSE,IF(Markers!$A$16=TRUE,'Data entry'!$B$10/100*('Data entry'!$B$6*C23)+((D23-('Data entry'!$B$6*C23))*'Data entry'!$B$11/100),\"\"),\"\")","v":""},{"$f":"IF(Markers!$A$7=FALSE,IF(Markers!$A$16=TRUE,housing_days*IF(Markers!$A$34=1,'Operating costs'!$B$8/1000*'Data entry'!$B$17,IF(Markers!$A$34=2,'Operating costs'!$B$10/1000*'Data entry'!$B$17,IF(Markers!$A$34=4,'Operating costs'!$B$11/1000*'Data entry'!$B$20,\"\"))),\"\"),\"\")","v":""},{"$f":"IF(Markers!$A$7=FALSE,IF(Markers!$A$16=TRUE,((housing_days*IF(Markers!$A$35=TRUE,labour*(IF(Markers!$A$34=1,manstraw,IF(Markers!$A$34=3,mansand,mansaw))),IF(OR(Markers!$A$36=TRUE,Markers!$A$37=TRUE),LabourR*(IF(Markers!$A$34=2,chopstraw,IF(Markers!$A$34=3,dispsand,dispsaw))),LabourR*IF(Markers!$A$34<>4,dispsand,dispsaw))))+(IF(OR(Markers!$A$24=TRUE,Markers!$A$31=TRUE),0,housing_days*scraping_charge)))/60,\"\"),\"\")","v":""},null,{"$f":"SUM(E23:I23)","v":0},{"$f":"J23/$K$9*100","v":0}]
[null,null,{"$f":"IF(AND(Markers!$A$7=FALSE,Markers!$A$8=FALSE,Markers!$C$8=FALSE),IF(Markers!$A$17=TRUE,'Capital costs'!D36,\"\"),\"\")","v":""},{"$f":"IF(AND(Markers!$A$7=FALSE,Markers!$A$8=FALSE,Markers!$C$8=FALSE),IF(Markers!$A$17=TRUE,IF(AND(Markers!$A$36=TRUE,Markers!$A$34=2),'Capital costs'!B60,IF(AND(Markers!$A$37=TRUE,Markers!$A$34=1),'Capital costs'!B63,IF(AND(Markers!$A$38=TRUE,Markers!$A$34=1),'Capital costs'!$B$64,IF(AND(Markers!$A$38=TRUE,Markers!$A$34=4),'Capital costs'!$B$62))))+'Data entry'!$B$6*C24,\"\"),\"\")","v":""},{"$f":"IF(AND(Markers!$A$7=FALSE,Markers!$A$8=FALSE,Markers!$C$8=FALSE),IF(Markers!$A$17=TRUE,'Data entry'!$B$12/100*D24,\"\"),\"\")","v":""},{"$f":"IF(AND(Markers!$A$7=FALSE,Markers!$A$8=FALSE,Markers!$C$8=FALSE),IF(Markers!$A$17=TRUE,'Data entry'!$B$10/100*('Data entry'!$B$6*C24)+((D24-('Data entry'!$B$6*C24))*'Data entry'!$B$11/100),\"\"),\"\")","v":""},{"$f":"IF(AND(Markers!$A$7=FALSE,Markers!$A$8=FALSE,Markers!$C$8=FALSE),IF(Markers!$A$17=TRUE,housing_days*IF(Markers!$A$34=1,'Operating costs'!$B$8/1000*'Data entry'!$B$17,IF(Markers!$A$34=2,'Operating costs'!$B$10/1000*'Data entry'!$B$17,IF(Markers!$A$34=4,'Operating costs'!$B$11/1000*'Data entry'!$B$20,\"\"))),\"\"),\"\")","v":""},{"$f":"IF(AND(Markers!$A$7=FALSE,Markers!$A$8=FALSE,Markers!$C$8=FALSE),IF(Markers!$A$17=TRUE,((housing_days*IF(Markers!$A$35=TRUE,labour*(IF(Markers!$A$34=1,manstraw,IF(Markers!$A$34=3,mansand,mansaw))),IF(OR(Markers!$A$36=TRUE,Markers!$A$37=TRUE),LabourR*(IF(Markers!$A$34=2,chopstraw,IF(Markers!$A$34=3,dispsand,dispsaw))),LabourR*IF(Markers!$A$34<>4,dispsand,dispsaw))))+(IF(OR(Markers!$A$24=TRUE,Markers!$A$31=TRUE),0,housing_days*scraping_charge)))/60,\"\"),\"\")","v":""},null,{"$f":"SUM(E24:I24)","v":0},{"$f":"J24/$K$9*100","v":0}]
[null,null,{"$f":"IF(AND(Markers!$A$7=FALSE,Markers!$A$8=FALSE,Markers!$C$8=FALSE),IF(Markers!$A$18=TRUE,'Capital costs'!D38,\"\"),\"\")","v":""},{"$f":"IF(AND(Markers!$A$7=FALSE,Markers!$A$8=FALSE,Markers!$C$8=FALSE),IF(Markers!$A$18=TRUE,IF(AND(Markers!$A$36=TRUE,Markers!$A$34=2),'Capital costs'!B60,IF(AND(Markers!$A$37=TRUE,Markers!$A$34=1),'Capital costs'!B63,IF(AND(Markers!$A$38=TRUE,Markers!$A$34=1),'Capital costs'!$B$64,IF(AND(Markers!$A$38=TRUE,Markers!$A$34=4),'Capital costs'!$B$62))))+'Data entry'!$B$6*C25,\"\"),\"\")","v":""},{"$f":"IF(AND(Markers!$A$7=FALSE,Markers!$A$8=FALSE,Markers!$C$8=FALSE),IF(Markers!$A$18=TRUE,'Data entry'!$B$12/100*D25,\"\"),\"\")","v":""},{"$f":"IF(AND(Markers!$A$7=FALSE,Markers!$A$8=FALSE,Markers!$C$8=FALSE),IF(Markers!$A$18=TRUE,'Data entry'!$B$10/100*('Data entry'!$B$6*C25)+((D25-('Data entry'!$B$6*C25))*'Data entry'!$B$11/100),\"\"),\"\")","v":""},{"$f":"IF(AND(Markers!$A$7=FALSE,Markers!$A$8=FALSE,Markers!$C$8=FALSE),IF(Markers!$A$18=TRUE,housing_days*IF(Markers!$A$34=1,'Operating costs'!$B$8/1000*'Data entry'!$B$17,IF(Markers!$A$34=2,'Operating costs'!$B$10/1000*'Data entry'!$B$17,IF(Markers!$A$34=4,'Operating costs'!$B$11/1000*'Data entry'!$B$20,\"\"))),\"\"),\"\")","v":""},{"$f":"IF(AND(Markers!$A$7=FALSE,Markers!$A$8=FALSE,Markers!$C$8=FALSE),IF(Markers!$A$18=TRUE,((housing_days*IF(Markers!$A$35=TRUE,labour*(IF(Markers!$A$34=1,manstraw,IF(Markers!$A$34=3,mansand,mansaw))),IF(OR(Markers!$A$36=TRUE,Markers!$A$37=TRUE),LabourR*(IF(Markers!$A$34=2,chopstraw,IF(Markers!$A$34=3,dispsand,dispsaw))),LabourR*IF(Markers!$A$34<>4,dispsand,dispsaw))))+(IF(OR(Markers!$A$24=TRUE,Markers!$A$31=TRUE),0,housing_days*scraping_charge)))/60,\"\"),\"\")","v":""},null,{"$f":"SUM(E25:I25)","v":0},{"$f":"J25/$K$9*100","v":0}]
[null,null,{"$f":"IF(Markers!$A$20=TRUE,'Capital costs'!D37,\"\")","v":""},{"$f":"IF(Markers!$A$20=TRUE,IF(AND(Markers!$A$38=TRUE,Markers!$A$34=3),'Capital costs'!B61,0)+'Data entry'!$B$6*C26,\"\")","v":""},{"$f":"IF(Markers!$A$20=TRUE,'Data entry'!$B$12/100*D26,\"\")","v":""},{"$f":"IF(Markers!$A$20=TRUE,'Data entry'!$B$10/100*('Data entry'!$B$6*C26)+((D26-('Data entry'!$B$6*C26))*'Data entry'!$B$11/100),\"\")","v":""},{"$f":"IF(Markers!$A$20=TRUE,housing_days*'Operating costs'!$B$12/1000*'Data entry'!$B$19,\"\")","v":""},{"$f":"IF(Markers!$A$20=TRUE,(housing_days*IF(Markers!$A$38=TRUE,'Operating costs'!$B$30*'Data entry'!$B$16,'Operating costs'!$B$29*'Data entry'!$B$15)+(IF(OR(Markers!$A$24=TRUE,Markers!$A$31=TRUE),0,housing_days*scraping_charge)))/60,\"\")","v":""},null,{"$f":"SUM(E26:I26)","v":0},{"$f":"J26/$K$9*100","v":0}]
[]
[null,"Additional features"]
[null,null,{"$f":"IF(Markers!$A24=TRUE,'Capital costs'!D30,\"\")","v":66},{"$f":"IF(Markers!$A$24=TRUE,'Data entry'!$B$6*C29,\"\")","v":6600},{"$f":"IF(Markers!$A$24=TRUE,'Data entry'!$B$12/100*D29,\"\")","v":330},{"$f":"IF(Markers!$A$24=TRUE,'Data entry'!$B$10/100*D29,\"\")","v":330},null,null,{"$f":"IF(Markers!$A$24=TRUE,('Data entry'!$B$6*'Capital costs'!$D$30*'Operating costs'!$B$36/100)+((housing_days)*'Operating costs'!$B$37*'Data entry'!$B$13/100),\"\")","v":492},{"$f":"SUM(E29:I29)","v":1152},{"$f":"J29/$K$9*100","v":0.16457142857142856}]
[null,null,{"$f":"IF(Markers!$A$25=TRUE,'Capital costs'!D48,\"\")","v":""},{"$f":"IF(Markers!$A$25=TRUE,'Data entry'!$B$6*C30,\"\")","v":""},{"$f":"IF(Markers!$A$25=TRUE,'Data entry'!$B$12/100*D30,\"\")","v":""},{"$f":"IF(Markers!$A$25=TRUE,'Data entry'!$B$10/100*D30,\"\")","v":""},null,null,{"$f":"IF(Markers!$A$25=TRUE,('Data entry'!$B$6*'Capital costs'!$D$48*'Operating costs'!$B$69/100)+(housing_days*'Operating costs'!$B$70*'Data entry'!$B$13/100),\"\")","v":""},0,0]
[null,null,{"$f":"IF(Markers!$A$27=TRUE,'Capital costs'!D41,\"\")","v":""},{"$f":"IF(Markers!$A$27=TRUE,'Data entry'!$B$6*C31,\"\")","v":""},{"$f":"IF(Markers!$A$27=TRUE,'Data entry'!$B$12/100*D31,\"\")","v":""},{"$f":"IF(Markers!$A$27=TRUE,'Data entry'!$B$10/100*D31,\"\")","v":""},null,null,{"$f":"IF(Markers!$A$27=TRUE,('Data entry'!$B$6*'Capital costs'!$D$41*'Operating costs'!$B$45/100)+(('Data entry'!$B$6*'Data entry'!$B$9)*'Operating costs'!$B$46*'Data entry'!$B$13/100),\"\")","v":""},0,0]
[null,null,{"$f":"IF(Markers!$A$28=TRUE,'Capital costs'!D42,\"\")","v":250},{"$f":"IF(Markers!$A$28=TRUE,'Data entry'!$B$6*C32,\"\")","v":25000},{"$f":"IF(Markers!$A$28=TRUE,'Data entry'!$B$12/100*D32,\"\")","v":1250},{"$f":"IF(Markers!$A$28=TRUE,'Data entry'!$B$10/100*D32,\"\")","v":1250},null,null,{"$f":"IF(Markers!$A$28=TRUE,('Data entry'!$B$6*'Capital costs'!$D$42*'Operating costs'!$B$45/100)+(('Data entry'!$B$6*'Data entry'!$B$9)*'Operating costs'!$B$49*'Data entry'!$B$13/100),\"\")","v":500},{"$f":"SUM(E32:I32)","v":3000},0.4285714285714286]
[null,null,{"$f":"IF(Markers!$A$29=TRUE,'Capital costs'!D44,\"\")","v":44},{"$f":"IF(Markers!$A$29=TRUE,'Data entry'!$B$6*C33,\"\")","v":4400},{"$f":"IF(Markers!$A$29=TRUE,'Data entry'!$B$12/100*D33,\"\")","v":220},{"$f":"IF(Markers!$A$29=TRUE,'Data entry'!$B$10/100*D33,\"\")","v":220},null,null,null,440,6.2857142857142848E-2]
[null,null,{"$f":"IF(Markers!$A$30=TRUE,'Capital costs'!D43,\"\")","v":""},{"$f":"IF(Markers!$A$30=TRUE,'Data entry'!$B$6*C34,\"\")","v":""},{"$f":"IF(Markers!$A$30=TRUE,'Data entry'!$B$12/100*D34,\"\")","v":""},{"$f":"IF(Markers!$A$30=TRUE,'Data entry'!$B$10/100*D34,\"\")","v":""},null,null,null,0,0]
[]
[null,"TOTAL",{"$f":"SUM(C29:C35,C22:C26,C12:C19)","v":1687.6},171510,8575.5,8713,4000,4166.666666666667,992,26447.166666666668,3.7781666666666669]
[null,"Budget",null,{"$f":"'Data entry'!B4","v":100000}]
[null,"Difference from budget",null,{"$f":"D36-D37","v":71510}]

{"sheet":"Data entry (3)","index":5,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[23,1,23,2]]}
["Parlour Wizard ~ existing parlour data entry"]
[]
[]
[]
[]
["Parlour type"]
["Number of units",10]
["Number of standings",{"$f":"IF(EXParl=\"herringbone 1:2\",B7*2,B7)","v":20}]
["Cows in milk"]
["Number of milking groups"]
["Milkings per day"]
["Number of people milking"]
["Milking duration in hours"]
[]
["Existing automation",null,null,"Existing milking routine"]
{"$rows_empty":8}
["Calculated Existing Parlour Speed",{"$f":"'Options (2)'!G26","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Markers!$L$2=TRUE,ROUND(B24*24,2),\"\")","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":4},"Action Points"]
[]
[{"$nulls":4},{"$f":"IF(Markers!$L$2=TRUE,IF(B13*110%<E24,\"Do you have a problem with milk quality?\",IF(E24*110%<B13,\"Could you milk more quickly with your existing parlour?\",\"\")),\"\")","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"IF(Markers!$L$2=TRUE,IF(B13*110%<E24,\"Is your milking routine good enough?\",IF(E24*110%<B13,\"How good is cow flow in and out of the parlour?\",\"\")),\"\")","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"IF(Markers!$L$2=TRUE,IF(E24*110%<B13,\"How clean are the cows coming in to the parlour?\",\"\"),\"\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"Operating costs (3)","index":6,"n_rows":103,"n_cols":7,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["Parlour Wizard operating costs"]
[]
[]
["Operations in seconds","1:1 herr.","1:2 herr","Int.rotary","Ext.rotary","Rapid exit","AutoTandem"]
["Marshalling",10,10,10,10,10,10]
["Loading cows in","varies","varies",1,0,"varies",15]
["In parlour feeding manual",3,3,3,3,0,3]
["In parlour feeding semi auto",1,1,1,1,0,1]
["In parlour feeding auto",0,0,0,0,0,0]
["Pre-dip",4,4,4,4,4,4]
["Pre-spray",2,2,2,2,2,2]
["Fore milk full",6,6,6,6,6,6]
["Fore milk selective",3,3,3,3,3,3]
["Teat preparation wash & dry",15,15,15,15,15,15]
["Teat preparation dry wipe",8,8,8,8,8,8]
["Teat preparation medi wipe",8,8,8,8,8,8]
["Cluster attachment",12,12,10,10,10,12]
["Cluster removal",5,5,5,5,5,5]
["Cluster flush all",10,10,10,10,10,10]
["Cluster flush selective",2,2,2,2,2,2]
["Cluster flush auto",0,0,0,0,0,0]
["Cluster flush none",0,0,0,0,0,0]
["Post disinfect dip",5,5,5,5,5,5]
["Post disinfect spray",2,2,2,2,2,2]
["Post disinfect auto",0,0,0,0,0,0]
["Unload cows",6,6,0,0,1,15]
["Shedding cows",3,3,3,3,3,3]
["Miscellaneous",10,10,10,10,10,10]
["Auto ID",-3,-3,-3,-3,-3,-3]
["Backing gate",-10,-10,-10,-10,-10,-10]
["ACRs",-4,-4,-4,-4,-4,-4]
[]
[]
["AMS cows milked/unit",70]
["Auto wash ~ seconds/wash",720]
[]
["Number milking","Units/man"]
["1:1 Herringbone",24]
["1:2 Herringbone",18]
["Internal rotary",20]
["External rotary","na","Minimum 2 men + auto spray"]
["Rapid exit",24]
["Auto tandem",8]
[]
[]
[]
["Parlour electricity",0.05,"kW/litre"]
["Chemical cost cleaning",0.3,"p/litre"]
["Chemical use pre dip",1.1000000000000001,"p/cow/milking"]
["Chemical use pre spray",1.65,"p/cow/milking"]
["Chemical use post dip",1.1499999999999999,"p/cow/milking"]
["Chemical use post spray",1.73,"p/cow/milking"]
["Chemical use post auto",4.5999999999999996,"p/cow/milking"]
["Chemical use autoflush",1.6,"p/cow/milking"]
["Chemical use auto dip & flush",2.75,"p/cow/milking"]
["Dry wipes",2,"p/cow/milking"]
["Medicated wipes",2.89,"p/cow/milking"]
["Liner cost",22.5,"£/set of 4"]
["Liner use",2500,"Milkings"]
["Parlour maintenance",0.45,"p/litre"]
["AMS chemical & sevice",3800,"£/unit"]
{"$rows_empty":39}
[{"$nulls":5},{"$f":"MID(J89,3,3)","v":""}]
[{"$nulls":5},{"$f":"MID(J90,3,3)","v":""}]
[{"$nulls":5},{"$f":"MID(J91,3,3)","v":""}]

{"sheet":"Capital costs (3)","index":7,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Parlour Wizard Capital Costs"]
[]
[]
["Parlour equipment costs"]
["Herringbone 1:1",1800,"£/standing"]
["Herringbone 1:2",1700,"£/standing"]
["Rapid exit",2800,"£/standing"]
["Auto tandem",7000,"£/standing"]
["Internal rotary",3250,"£/standing"]
["External rotary",3250,"£/standing"]
["AMS",110000,"£/unit"]
[]
[]
["Automation costs"]
[]
["Autoshedding",5000,"£"]
["Auto ID",4500,"£"]
["Transponders",28,"£/cow"]
["Backing gate",12000,"£"]
["Autowashing",3600,"£"]
["Automatic dip & flush",1040,"£/unit"]
["Auto teat spray",4000]
["Auto Cluster Flush",550,"£/unit"]
["ACRs",500,"£/unit"]
["In parlour feeders",600,"£/standing"]
["Electronic milk meters",800,"£/unit"]
["Manual milk meters",180,"£/unit"]
["Bulk tank < 10000",1.5,"£/litre < 10,000"]
["Bulk tank > 10000",2.2999999999999998,"£/litre 10,001 to 25,000"]
["Milk silo",2.8,"£/litre > 25,000"]
[]
["Parlour building costs"]
[]
["Herringbone 1:1",1384,"£/standing"]
["Herringbone 1:2",1796,"£/standing"]
["Rapid exit",2772,"£/standing"]
["Auto tandem",6930,"£/standing"]
["Internal rotary",1770,"£/standing"]
["External rotary",1770,"£/standing"]
["AMS",22000,"£/unit"]
["Dairy building for bulk tank",209,"£/cow"]
["Dairy building for silo",55,"£/cow"]
["Collecting yard",129,"£/cow"]
["AI stalls",39,"£/cow"]
["Cattle race",17,"£/cow"]

{"sheet":"Options (2)","index":8,"n_rows":36,"n_cols":22,"rows_kept":36,"cut":false,"hidden":false,"merged":[[27,0,28,2],[8,10,8,11],[9,10,9,11],[10,10,11,11]]}
["Planned Parlour Options"]
[]
[]
[]
["Data entry ",null,null,null,"Investment required"]
[]
["Planned herd size"]
["Planned cows in milk",{"$nulls":5},"Capacity"]
["Planned yield",{"$nulls":9},"Total Cost"]
["Planned annual litres",{"$f":"herd*B9","v":0},{"$nulls":8},{"$f":"Report!E14","v":0}]
["Planned milkings/day",{"$nulls":9},{"$f":"IF(K10>B13,\"You have exceeded your set budget\",\"\")","v":""}]
["Target Milking Time"]
["Planned budget"]
[]
["Planned automation",null,null,null,"Planned milking routine"]
{"$rows_empty":8}
["Parlour configuration",{"$nulls":4},"People","Milking time","Cows/hour","Litres"]
[null,null,null,"Units","Standings","milking","minutes","per man","/hour"]
["Existing calculated",{"$f":"IF(Markers!$L$2=TRUE,EXParl,\"\")","v":"Herringbone 1:2"},null,{"$f":"IF(Markers!$L$2=TRUE,'Data entry (3)'!B7,\"\")","v":10},{"$f":"IF(Markers!$L$2=TRUE,'Data entry (3)'!B8,\"\")","v":20},{"$f":"IF(Markers!$L$2=TRUE,'Data entry (3)'!B12,\"\")","v":0},{"$f":"IF(Markers!$G$28=TRUE,'Options (2)'!$N26*0.9,'Options (2)'!$N26)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Markers!$L$2=TRUE,ROUND(CIMex/G26/F26/24,0),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Markers!$L$2=TRUE,ROUND((annuallitresex/365/$B$11)/G26/24,0),\"\")","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"IF(Markers!$L$2=TRUE,IF(EXParl=\"Ams\",CIMex*aroutine,IF(OR(EXParl=\"external rotary\",EXParl=\"internal rotary\"),Automationtimeex*CIMex+udderroutineex*LabourFactorEx*CIMex+misctimesex*LabourFactorEx*CIMex+10*LabourFactorEx*CIMex,IF(OR(EXParl=\"Auto tandem\",EXParl=\"Abreast\"),Automationtimeex*CIMex+udderroutineex*LabourFactorEx*CIMex+misctimesex*LabourFactorEx*CIMex+12*LabourFactorEx*CIMex+(CIMex*30),IF(EXParl=\"rapid exit\",(Automationtimeex*(CIMex)+udderroutineex*LabourFactorEx*(CIMex)+10*LabourFactorEx*CIMex+(VLOOKUP($E$26/2,loading,3)*(CIMex/($E$26*0.5)))+misctimesex*LabourFactorEx*(CIMex)),IF(EXParl=\"herringbone 1:2\",((Automationtimeex*(CIMex)+udderroutineex*LabourFactorEx*(CIMex)+misctimesex*LabourFactorEx*CIMex+12*LabourFactorEx*CIMex+(VLOOKUP($E$26/2,loading,3)*(CIMex/($E$26*0.5)))+6*CIMex)*IF(YrCalving=FALSE,0.9,1)),Automationtimeex*CIMex+udderroutineex*LabourFactorEx*CIMex+6*CIMex+12*LabourFactorEx*CIMex+(VLOOKUP($E$26/2,loading,3)*(CIMex/($E$26*0.5)))+misctimesex*LabourFactorEx*CIMex))))+IF(EXParl<>\"AMS\",autowashex,0))/60/60/24,\"\")","v":{"$error":"#DIV/0!"}}]
["Existing actual",{"$f":"IF(Markers!$L$2=TRUE,EXParl,\"\")","v":"Herringbone 1:2"},null,{"$f":"IF(Markers!$L$2=TRUE,'Data entry (3)'!B7,\"\")","v":10},{"$f":"IF(Markers!$L$2=TRUE,'Data entry (3)'!B8,\"\")","v":20},{"$f":"IF(Markers!$L$2=TRUE,'Data entry (3)'!B12,\"\")","v":0},{"$f":"IF(Markers!$L$2=TRUE,'Data entry (3)'!B13/24,\"\")","v":"00:00:00"},{"$f":"IF(Markers!$L$2=TRUE,ROUND(('Data entry (3)'!B9/(G27*24)),0)/F27,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Markers!$L$2=TRUE,ROUND((annuallitresex/365/$B$11)/G27/24,0),\"\")","v":{"$error":"#DIV/0!"}}]
["Select a configuration below to include in report",{"$nulls":4},"People","Milking time","Cows/hour","Litres"]
[null,null,null,"Units","Standings","milking","minutes","per man","/hour"]
["Herringbone 1:1",null,null,20,{"$f":"D30","v":20},1,{"$f":"IF(Markers!$H$28=TRUE,'Options (2)'!$N30*0.9,'Options (2)'!$N30)","v":"00:00:00"},{"$f":"ROUND(CIM/G30/F30/24,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((annuallitres/365/$B$11)/G30/24,0)","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"((Automationtime*CIM+udderroutine*LabourFactorII*CIM+misctimes*LabourFactorII*CIM+12*LabourFactorII*CIM+(VLOOKUP($E$30/2,loading,3)*(CIM/($E$30*0.5)))+6*CIM+IF(parlourname<>\"AMS\",autowash,0))*IF(YrCalving=TRUE,0.9,1))/60/60/24","v":0},{"$nulls":7},{"$f":"IF(ISNUMBER(U30),IF((U30+1)>4,\"\",U30+1),\"\")","v":""}]
["Herringbone 1:2",null,null,10,{"$f":"D31*2","v":20},1,{"$f":"IF(Markers!$H$28=TRUE,'Options (2)'!$N31*0.9,'Options (2)'!$N31)","v":"00:00:00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":4},{"$f":"((Automationtime*CIM+udderroutine*LabourFactorII*CIM+misctimes*LabourFactorII*CIM+12*LabourFactorII*CIM+(VLOOKUP($E$31/2,loading,3)*(CIM/($E$31*0.5)))+6*CIM+IF(parlourname<>\"AMS\",autowash,0))*IF(YrCalving=FALSE,0.9,1))/60/60/24","v":0},{"$nulls":7},""]
["Rapid exit",null,null,20,{"$f":"D32","v":20},1,{"$f":"IF(Markers!$H$28=TRUE,'Options (2)'!$N32*0.9,'Options (2)'!$N32)","v":"00:00:00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":4},{"$f":"(Automationtime*CIM+udderroutine*LabourFactorII*CIM+misctimes*LabourFactorII*CIM+10*LabourFactorII*CIM+(VLOOKUP($E$32/2,loading,3)*(CIM/($E$32*0.5)))+IF(parlourname<>\"AMS\",autowash,0))/60/60/24","v":0},{"$nulls":7},""]
["Auto tandem",null,null,10,{"$f":"D33","v":10},1,{"$f":"IF(Markers!$H$28=TRUE,'Options (2)'!$N33*0.9,'Options (2)'!$N33)","v":"00:00:00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":4},{"$f":"(Automationtime*CIM+udderroutine*LabourFactorII*CIM+misctimes*LabourFactorII*CIM+12*LabourFactorII*CIM+(CIM*30)+IF(parlourname<>\"AMS\",autowash,0))/60/60/24","v":0},{"$nulls":7},""]
["Internal rotary",null,null,30,{"$f":"D34","v":30},2,{"$f":"IF(Markers!$H$28=TRUE,'Options (2)'!$N34*0.9,'Options (2)'!$N34)","v":"00:00:00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":4},{"$f":"(Automationtime*CIM+udderroutine*LabourFactorII*CIM+misctimes*LabourFactorII*CIM+10*LabourFactorII*CIM+IF(parlourname<>\"AMS\",autowash,0))/60/60/24","v":0},{"$nulls":7},""]
["External rotary",null,null,40,{"$f":"D35","v":40},2,{"$f":"IF(Markers!$H$28=TRUE,'Options (2)'!$N35*0.9,'Options (2)'!$N35)","v":"00:00:00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":4},{"$f":"(Automationtime*CIM+udderroutine*LabourFactorII*CIM+misctimes*LabourFactorII*CIM+10*LabourFactorII*CIM+IF(parlourname<>\"AMS\",autowash,0))/60/60/24","v":0},{"$nulls":7},""]
["AMS",null,null,{"$f":"E36","v":0},{"$f":"ROUNDUP(CIM/70,0)","v":0}]

{"sheet":"Report","index":9,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
[{"$f":"CONCATENATE(\"Financial Report \",\"for \", VLOOKUP(TRUE,parlourtype,2,FALSE),\" Parlour Option\")","v":"Financial Report for Herringbone 1:1 Parlour Option"}]
[]
[]
[{"$nulls":5},"                     Operating     costs      £/annum"]
[null,null,null,"Cost £/cow","£ total","Interest","Depreciation","Labour","Other","Total","p/litre"]
[{"$f":"IF('Options (2)'!H8>=25000,\"Dairy building with silo\",\"Dairy Building for bulk tank\")","v":"Dairy Building for bulk tank"},{"$f":"IF(Markers!H36=TRUE,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(B6=\"yes\",VLOOKUP(A6,buildingcosts,2,FALSE),\"\")","v":""},{"$f":"IF(B6=\"yes\",(VLOOKUP(A6,buildingcosts,2,FALSE))*herd,\"\")","v":""},{"$f":"IF(ISNUMBER(E6),$E6*'Dairy Wizard'!$B$8%,\"\")","v":""},{"$f":"IF(ISNUMBER(F6),$E6*'Dairy Wizard'!$B$6%,\"\")","v":""},null,null,{"$f":"IF(B6=\"yes\",SUM(F6:I6),\"\")","v":""},{"$f":"IF(B6=\"yes\",J6*100/annuallitres,\"\")","v":""}]
[{"$f":"IF(B7=\"yes\",IF('Options (2)'!H8>=25000,\"Milk silo\",IF('Options (2)'!H8>=10001,\"Bulk tank > 10000\",\"Bulk tank < 10000\")),\"Bulk tank/Milk silo\")","v":"Bulk tank/Milk silo"},{"$f":"IF(Markers!H37=TRUE,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(B7=\"yes\",E7/herd,\"\")","v":""},{"$f":"IF(B7=\"yes\",VLOOKUP(A7,equipcosts,2,FALSE)*'Options (2)'!H8,\"\")","v":""},{"$f":"IF(ISNUMBER(E7),$E7*'Dairy Wizard'!$B$8%,\"\")","v":""},{"$f":"IF(ISNUMBER(F7),$E7*'Dairy Wizard'!$B$7%,\"\")","v":""},null,null,"",""]
["Collecting yard",{"$f":"IF(Markers!H38=TRUE,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(B8=\"yes\",VLOOKUP(A8,buildingcosts,2,FALSE),\"\")","v":""},{"$f":"IF(B8=\"Yes\",VLOOKUP(A8,buildingcosts,2,FALSE)*herd,\"\")","v":""},{"$f":"IF(ISNUMBER(E8),$E8*'Dairy Wizard'!$B$8%,\"\")","v":""},{"$f":"IF(ISNUMBER(F8),$E8*'Dairy Wizard'!$B$6%,\"\")","v":""},null,null,"",""]
["AI stalls",{"$f":"IF(Markers!H39=TRUE,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(B9=\"yes\",E9/herd,\"\")","v":""},{"$f":"IF(B9=\"yes\",(VLOOKUP(A9,buildingcosts,2,FALSE)+'Capital costs (3)'!B45)*herd,\"\")","v":""},{"$f":"IF(ISNUMBER(E9),$E9*'Dairy Wizard'!$B$8%,\"\")","v":""},{"$f":"IF(ISNUMBER(F9),$E9*'Dairy Wizard'!$B$6%,\"\")","v":""},null,null,"",""]
["Parlour building",{"$f":"IF(Markers!H40=TRUE,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(B10=\"yes\",(VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),buildingcosts,2,FALSE)*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourconfiguration,5,FALSE))/herd,\"\")","v":""},{"$f":"IF(B10=\"yes\",(VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),buildingcosts,2,FALSE))*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourconfiguration,5,FALSE),\"\")","v":""},{"$f":"IF(ISNUMBER(E10),$E10*'Dairy Wizard'!$B$8%,\"\")","v":""},{"$f":"IF(ISNUMBER(F10),$E10*'Dairy Wizard'!$B$6%,\"\")","v":""},null,null,"",""]
["Parlour equipment",{"$f":"IF(Markers!H42=TRUE,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(B11=\"yes\",(VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourcosts,2,FALSE)*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourconfiguration,5,FALSE))/herd,\"\")","v":""},{"$f":"IF(B11=\"yes\",(VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourcosts,2,FALSE))*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourconfiguration,5,FALSE),\"\")","v":""},{"$f":"IF(ISNUMBER(E11),$E11*'Dairy Wizard'!$B$8%,\"\")","v":""},{"$f":"IF(ISNUMBER(F11),$E11*'Dairy Wizard'!$B$7%,\"\")","v":""},null,null,"",""]
["Additional automation",{"$f":"IF(AND(Markers!J17>0,Markers!H43=TRUE),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(ISNUMBER(E12),E12/herd,\"\")","v":""},{"$f":"IF(B12=\"yes\",Markers!J17,\"\")","v":""},{"$f":"IF(ISNUMBER(E12),$E12*'Dairy Wizard'!$B$8%,\"\")","v":""},{"$f":"IF(ISNUMBER(F12),$E12*'Dairy Wizard'!$B$7%,\"\")","v":""},null,null,"",""]
["Labour & other costs",{"$nulls":6},{"$f":"'Dairy Wizard'!B11*'Options (2)'!B11*(IF(Markers!$H$23=FALSE,0.2*'Options (2)'!$B$11*365,0)/60/60/24+VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourdetails,7,FALSE)*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourdetails,6,FALSE))*24*365","v":0},{"$f":"IF(VLOOKUP(TRUE,parlourtype,2,FALSE)=\"AMS\",'Operating costs (3)'!B61*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourconfiguration,4,FALSE),Markers!I56)","v":803},{"$f":"SUM(H13:I13)","v":803},{"$f":"(J13/annuallitres)*100","v":{"$error":"#DIV/0!"}}]
["TOTAL",null,null,{"$f":"SUM(D6:D13)","v":0},{"$f":"SUM(E6:E13)","v":0},0,0,0,803,803,{"$f":"(J14/annuallitres)*100","v":{"$error":"#DIV/0!"}}]
["Budget",null,null,null,{"$f":"'Options (2)'!B13","v":0},null,"Existing parlour",{"$f":"IF(Markers!$L$2=TRUE,'Dairy Wizard'!B11*'Options (2)'!B11*(IF(Markers!$G$23=FALSE,0.2*'Options (2)'!$B$11*365,0)/60/60/24+'Options (2)'!G27*'Options (2)'!F26)*24*365,\"\")","v":0},{"$f":"IF(Markers!$L$2=TRUE,Markers!G56,\"\")","v":730},{"$f":"IF(Markers!$L$2=TRUE,H15+I15,\"\")","v":730},{"$f":"IF(Markers!$L$2=TRUE,J15/(herdex*yieldex)*100,\"\")","v":{"$error":"#DIV/0!"}}]
["Difference from budget",null,null,null,{"$f":"E14-E15","v":0},null,"Difference",{"$f":"IF(Markers!$L$2=TRUE,H14-H15,\"\")","v":0},{"$f":"IF(Markers!$L$2=TRUE,I14-I15,\"\")","v":73},{"$f":"IF(Markers!$L$2=TRUE,J14-J15,\"\")","v":73},{"$f":"IF(Markers!$L$2=TRUE,K14-K15,\"\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[{"$f":"IF(E16>0,\"Action points\",\"\")","v":""},{"$nulls":5},{"$f":"IF(ISNUMBER(K16),\"Action points\",\"\")","v":""}]
[]
[{"$f":"IF(E16>0,\"You have exceeded your budget\",\"\")","v":""},{"$nulls":5},{"$f":"IF(ISNUMBER(K16),\"You have increased your parlour running costs\",\"\")","v":""}]
[{"$f":"IF(E16>0,\"Consider cheaper options\",\"\")","v":""},{"$nulls":5},{"$f":"IF(ISNUMBER(K16),\"Consider increasing milk output to dilute the increased cost\",\"\")","v":""}]

{"sheet":"Data entry (4)","index":10,"n_rows":75,"n_cols":19,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["Slurry Wizard ~ Data entry"]
[]
[]
[]
["Total farmable area",0,"hectares"]
["Telephone STD code","01262"]
["Cows in herd",{"$f":"'Dairy Wizard'!B4","v":0},"cows"]
["Cows in milk",80,"cows"]
["Depreciation buildings",{"$f":"'Dairy Wizard'!B6","v":5},"%"]
["Depreciation machinery",{"$f":"'Dairy Wizard'!B7","v":10},"%"]
["Interest rate",{"$f":"'Dairy Wizard'!B8","v":5},"%"]
["Electricity cost",{"$f":"'Dairy Wizard'!B9","v":10},"p/kW hour"]
["Water cost",{"$f":"'Dairy Wizard'!B10","v":1},"£/cubic metre"]
["Slurry spreading cost",1.7,"£/cubic metre"]
["Water storage cost",0.45,"£/cubic metre"]
["Divert water cost",4.5999999999999996,"£/square metre"]
["Roofing cost",74,"£/square metre"]
["Slurry storage cost",35,"£/cubic metre"]
[]
["Slurry storage capacity"]
[]
[null,"Length m","Width m","Circumference of circular store m","Depth m (less freeboard)","Capacity m3","Area m2","Tick if Covered Store"]
["Store 1",{"$nulls":4},{"$f":"ROUND(B23*C23*E23,0)","v":0},{"$f":"IF($S23=TRUE,\"\",ROUND(B23*C23,0))","v":0},{"$nulls":11},false]
["Store 2",{"$nulls":4},{"$f":"ROUND(B24*C24*E24,0)","v":0},{"$f":"IF($S24=TRUE,\"\",ROUND(B24*C24,0))","v":0},{"$nulls":11},false]
["Store 3",{"$nulls":4},{"$f":"ROUND(B25*C25*E25,0)","v":0},{"$f":"IF($S25=TRUE,\"\",ROUND(B25*C25,0))","v":0},{"$nulls":11},false]
["Store 4",{"$nulls":4},{"$f":"ROUND(B26*C26*E26,0)","v":0},{"$f":"IF($S26=TRUE,\"\",ROUND(B26*C26,0))","v":0},{"$nulls":11},false]
["store 5",{"$nulls":4},{"$f":"ROUND(I27*E27,0)","v":0},{"$f":"IF($S27=TRUE,\"\",I27)","v":0},null,{"$f":"ROUND(($J27*$J27)*3.142,0)","v":0},{"$f":"(D27/3.142)/2","v":0},{"$nulls":8},false]
["store 6",{"$nulls":4},{"$f":"ROUND(I28*E28,0)","v":0},{"$f":"IF($S28=TRUE,\"\",I28)","v":0},null,{"$f":"ROUND(($J28*$J28)*3.142,0)","v":0},{"$f":"(D28/3.142)/2","v":0},{"$nulls":8},false]
["Total existing capacity ",{"$nulls":4},{"$f":"SUM(F23:F28)","v":0},{"$f":"SUM(G23:G28)","v":0}]
[]
["Freeboard : reduce the depth to allow for freeboard (0.3 metres for a steel or concrete store and 0.75 metres for a lagoon)"]
[]
["Slurry separator"]
[]
["Do you operate a separator","No","For the slurry entering the store(s)"]
["% reduction in slurry",20,"Adjust the % to reflect the average reduction in slurry volume"]
[]
["Parlour washings to slurry store"]
[]
["Parlour washings to slurry store","Yes"]
["High volume washing"]
["Low volume washing"]
["Own value"]
[]
["Uncovered dirty yard area to slurry store"]
[]
[null,"Length m","Width m","Area m2"]
["Yard 1",null,null,{"$f":"B48*C48","v":0}]
["Yard 2",null,null,0]
["Yard 3",null,null,0]
["Yard 4",null,null,0]
["Yard 5",null,null,0]
["Yard 6",null,null,0]
["Yard 7",null,null,0]
["Yard 8",null,null,0]
["Yard 9",null,null,0]
["Yard 10",null,null,0]
["Yard 11",null,null,0]
["Yard 12",null,null,0]
["Total yard area",null,null,{"$f":"SUM(D48:D59)","v":0}]
[]
["Roof water area to slurry store"]
[]
[null,"Length m","Width m","Area m2"]
["Roof 1",null,null,{"$f":"B65*C65","v":0}]
["Roof 2",null,null,0]
["Roof 3",null,null,0]
["Roof 4",null,null,0]
["Roof 5",null,null,0]
["Roof 6",null,null,0]
["Roof 7",null,null,0]
["Roof 8",null,null,0]
["Roof 9",null,null,0]
["Roof 10",null,null,0]
["Total roof area",null,null,{"$f":"SUM(D65:D74)","v":0}]

{"sheet":"Livestock","index":11,"n_rows":66,"n_cols":9,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Livestock data entry ~ Enter all livestock below"]
[]
[]
[]
["Livestock ","Age","Liveweight/milk yield","Number","% collected as slurry","Daily excreta","Total collected as slurry","Annual N output kg/year","Total N"]
[{"$nulls":8},"(kg/year)"]
["Cattle"]
["Dairy Cow","After first calf","High (>9000)",null,1,64,{"$f":"D8*E8*F8","v":0},115,{"$f":"SUM(D8*H8)","v":0}]
["Dairy Cow","After first calf","Medium (6000-9000)",null,0.85,53,0,101,0]
["Dairy Cow","After first calf","Low (<6000)",null,1,42,0,77,0]
["Dairy heifer replacement","13 mths to calving",null,null,1,40,0,61,0]
["Dairy heifer replacement","3<13 months",null,null,1,20,0,29,0]
["Beef Suckler",">25 months","Large (>500)",null,1,45,0,83,0]
["Beef Suckler",">25 months","Small (<500)",null,1,32,0,61,0]
["Grower",">25 months",null,null,1,32,0,50,0]
["Grower","13<25 months",null,null,1,26,0,50,0]
["Grower","3<13 months",null,null,1,20,0,34,0]
["Bull Beef",">3 months",null,null,1,26,0,54,0]
["Bulls for breeding",">25 months",null,null,1,26,0,48,0]
["Bulls for breeding","3<25 months",null,null,1,26,0,50,0]
["Calf","< 3 months",null,null,1,7,0,8.4,0]
["Pigs"]
["1 sow place inc. litters","Litter up to 7kg","with syn amino acid",null,1,11,{"$f":"D23*E23*F23","v":0},16,{"$f":"SUM(D23*H23)","v":0}]
["1 sow place inc. litters","Litter up to 7kg","no syn amino acid",null,1,11,0,18,0]
["Weaner place",null,"7 to 13kg",null,1,1,0,1,0]
["Weaner place",null,"13 to 31kg",null,1,1.67,0,4.2,0]
["Grower place","Dry fed","31 to 66kg",null,1,3.33,0,7.7,0]
["Grower place","Liquid fed","31 to 66kg",null,1,6,0,7.7,0]
["Finisher place","Dry fed",">66kg",null,1,4.33,0,10.6,0]
["Finisher place","Liquid fed",">66kg",null,1,8.67,0,10.6,0]
["Maiden gilt place",null,">66kg",null,1,4.33,0,11.1,0]
["Boar","66kg to 150kg",null,null,1,5,0,12,0]
["Boar","Above 150kg",null,null,1,8.67,0,17.5,0]
["Sheep"]
["Ewe","Lamb < 6 months","<60kg",null,0,3.33,{"$f":"D35*E35*F35","v":0},7.6,{"$f":"SUM(D35*H35)","v":0}]
["Ewe","Lamb < 6 months",">60kg",null,0,5,{"$f":"D36*E36*F36","v":0},11.9,{"$f":"SUM(D36*H36)","v":0}]
["Lamb","6 to 9 months",null,null,0,1.67,{"$f":"D37*E37*F37","v":0},0.5,{"$f":"SUM(D37*H37)","v":0}]
["Lamb","> 9 months",null,null,0,1.67,{"$f":"D38*E38*F38","v":0},0.7,{"$f":"SUM(D38*H38)","v":0}]
["Goats"]
["Goat ",null,null,null,0,3.67,{"$f":"D40*E40*F40","v":0},15,{"$f":"SUM(D40*H40)","v":0}]
["Deer"]
["Breeding hinds",null,null,null,0,5,{"$f":"D42*E42*F42","v":0},15.2,{"$f":"SUM(D42*H42)","v":0}]
["Other deer",null,null,null,0,3.67,{"$f":"D43*E43*F43","v":0},12,{"$f":"SUM(D43*H43)","v":0}]
["Horses"]
["Horse ",null,null,null,0,24.67,{"$f":"D45*E45*F45","v":0},21,{"$f":"SUM(D45*H45)","v":0}]
["Layers"]
["Replacement layer pullets","<17 weeks",null,null,0,3.6700000000000003E-2,{"$f":"D47*E47*F47","v":0},0.21,{"$f":"SUM(D47*H47)","v":0}]
["Laying hens - cages",">17 weeks",null,null,0,0.1167,{"$f":"D48*E48*F48","v":0},0.4,{"$f":"SUM(D48*H48)","v":0}]
["Laying hens - free range",">17 weeks",null,null,0,9.9000000000000005E-2,{"$f":"D49*E49*F49","v":0},0.46,{"$f":"SUM(D49*H49)","v":0}]
["Broilers"]
["Broiler places",null,null,null,0,0.05,{"$f":"D51*E51*F51","v":0},0.33,{"$f":"SUM(D51*H51)","v":0}]
["Broiler breeder pullets","<25 weeks",null,null,0,3.6700000000000003E-2,{"$f":"D52*E52*F52","v":0},0.28999999999999998,{"$f":"SUM(D52*H52)","v":0}]
["Broiler breeders",">25 weeks",null,null,0,0.113,{"$f":"D53*E53*F53","v":0},0.7,{"$f":"SUM(D53*H53)","v":0}]
["Turkeys"]
["Male",null,null,null,0,0.14299999999999999,{"$f":"D55*E55*F55","v":0},1.23,{"$f":"SUM(D55*H55)","v":0}]
["Female",null,null,null,0,0.1067,{"$f":"D56*E56*F56","v":0},0.91,{"$f":"SUM(D56*H56)","v":0}]
["Other"]
["Ducks",null,null,null,0,8.3299999999999999E-2,{"$f":"D58*E58*F58","v":0},0.75,{"$f":"SUM(D58*H58)","v":0}]
["Ostriches",null,null,null,0,1.4E-3,{"$f":"D59*E59*F59","v":0},1.4,{"$f":"SUM(D59*H59)","v":0}]
["TOTAL",{"$nulls":5},{"$f":"SUM(G8:G59)","v":0},null,{"$f":"SUM(I8:I59)","v":0}]
[]
["Farm Nitogen Loading"]
[]
["Kg Nitrogen per Ha",{"$f":"IF(ISNUMBER(I60/'Data entry (4)'!B5),I60/'Data entry (4)'!B5,\"\")","v":""}]
[]
["This is the nitrogen loading BEFORE the import or export of manure"]

{"sheet":"Slurry report","index":12,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Slurry Report"]
[]
[]
[]
["Cubic metres",null,"Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Total"]
["Days",null,31,30,31,31,28,31,30,31,30,31,31,30,{"$f":"SUM(C6:N6)","v":365}]
["Total excreta as slurry",null,{"$f":"(Livestock!$G$60/1000)*C6","v":0},{"$f":"(Livestock!$G$60/1000)*D6","v":0},{"$f":"(Livestock!$G$60/1000)*E6","v":0},{"$f":"(Livestock!$G$60/1000)*F6","v":0},{"$f":"(Livestock!$G$60/1000)*(G6+1)","v":0},{"$f":"(Livestock!$G$60/1000)*H6","v":0},{"$f":"(Livestock!$G$60/1000)*I6","v":0},{"$f":"(Livestock!$G$60/1000)*J6","v":0},{"$f":"(Livestock!$G$60/1000)*K6","v":0},{"$f":"(Livestock!$G$60/1000)*L6","v":0},{"$f":"(Livestock!$G$60/1000)*M6","v":0},{"$f":"(Livestock!$G$60/1000)*N6","v":0},{"$f":"SUM(C7:N7)","v":0}]
["% excreta to slurry store",null,50,100,100,100,100,100,20,20,20,20,20,20]
["Excreta to slurry store",null,{"$f":"C7*C8/100","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C9:N9)","v":0}]
["Slurry separated",{"$f":"CONCATENATE('Data entry (4)'!$B$35,IF('Data entry (4)'!$B$35=\"no\",,CONCATENATE(\" / \",'Data entry (4)'!$B$36,\"%\")))","v":"No"},{"$f":"IF($B$10=\"no\",0,(C9+C11+C13+C14+C15)*('Data entry (4)'!$B$36%))","v":0},{"$f":"IF($B$10=\"no\",0,(D9+D11+D13+D14+D15)*('Data entry (4)'!$B$36%))","v":0},{"$f":"IF($B$10=\"no\",0,(E9+E11+E13+E14+E15)*('Data entry (4)'!$B$36%))","v":0},{"$f":"IF($B$10=\"no\",0,(F9+F11+F13+F14+F15)*('Data entry (4)'!$B$36%))","v":0},{"$f":"IF($B$10=\"no\",0,(G9+G11+G13+G14+G15)*('Data entry (4)'!$B$36%))","v":0},{"$f":"IF($B$10=\"no\",0,(H9+H11+H13+H14+H15)*('Data entry (4)'!$B$36%))","v":0},{"$f":"IF($B$10=\"no\",0,(I9+I11+I13+I14+I15)*('Data entry (4)'!$B$36%))","v":0},{"$f":"IF($B$10=\"no\",0,(J9+J11+J13+J14+J15)*('Data entry (4)'!$B$36%))","v":0},{"$f":"IF($B$10=\"no\",0,(K9+K11+K13+K14+K15)*('Data entry (4)'!$B$36%))","v":0},{"$f":"IF($B$10=\"no\",0,(L9+L11+L13+L14+L15)*('Data entry (4)'!$B$36%))","v":0},{"$f":"IF($B$10=\"no\",0,(M9+M11+M13+M14+M15)*('Data entry (4)'!$B$36%))","v":0},{"$f":"IF($B$10=\"no\",0,(N9+N11+N13+N14+N15)*('Data entry (4)'!$B$36%))","v":0},0]
["Parlour washings",{"$f":"'Data entry (4)'!B40","v":"Yes"},{"$f":"IF($B$11=\"yes\",IF('Data entry (4)'!$B$43=\"\",IF('Data entry (4)'!$B$41=1,30,20),'Data entry (4)'!$B$43),0)*'Data entry (4)'!$B$8*31/10^3","v":49.6},{"$f":"IF($B$11=\"yes\",IF('Data entry (4)'!$B$43=\"\",IF('Data entry (4)'!$B$41=1,30,20),'Data entry (4)'!$B$43),0)*'Data entry (4)'!$B$8*30/10^3","v":48},{"$f":"IF($B$11=\"yes\",IF('Data entry (4)'!$B$43=\"\",IF('Data entry (4)'!$B$41=1,30,20),'Data entry (4)'!$B$43),0)*'Data entry (4)'!$B$8*31/10^3","v":49.6},{"$f":"IF($B$11=\"yes\",IF('Data entry (4)'!$B$43=\"\",IF('Data entry (4)'!$B$41=1,30,20),'Data entry (4)'!$B$43),0)*'Data entry (4)'!$B$8*31/10^3","v":49.6},{"$f":"IF($B$11=\"yes\",IF('Data entry (4)'!$B$43=\"\",IF('Data entry (4)'!$B$41=1,30,20),'Data entry (4)'!$B$43),0)*'Data entry (4)'!$B$8*28/10^3","v":44.8},{"$f":"IF($B$11=\"yes\",IF('Data entry (4)'!$B$43=\"\",IF('Data entry (4)'!$B$41=1,30,20),'Data entry (4)'!$B$43),0)*'Data entry (4)'!$B$8*31/10^3","v":49.6},{"$f":"IF($B$11=\"yes\",IF('Data entry (4)'!$B$43=\"\",IF('Data entry (4)'!$B$41=1,30,20),'Data entry (4)'!$B$43),0)*'Data entry (4)'!$B$8*30/10^3","v":48},{"$f":"IF($B$11=\"yes\",IF('Data entry (4)'!$B$43=\"\",IF('Data entry (4)'!$B$41=1,30,20),'Data entry (4)'!$B$43),0)*'Data entry (4)'!$B$8*31/10^3","v":49.6},{"$f":"IF($B$11=\"yes\",IF('Data entry (4)'!$B$43=\"\",IF('Data entry (4)'!$B$41=1,30,20),'Data entry (4)'!$B$43),0)*'Data entry (4)'!$B$8*30/10^3","v":48},{"$f":"IF($B$11=\"yes\",IF('Data entry (4)'!$B$43=\"\",IF('Data entry (4)'!$B$41=1,30,20),'Data entry (4)'!$B$43),0)*'Data entry (4)'!$B$8*31/10^3","v":49.6},{"$f":"IF($B$11=\"yes\",IF('Data entry (4)'!$B$43=\"\",IF('Data entry (4)'!$B$41=1,30,20),'Data entry (4)'!$B$43),0)*'Data entry (4)'!$B$8*31/10^3","v":49.6},{"$f":"IF($B$11=\"yes\",IF('Data entry (4)'!$B$43=\"\",IF('Data entry (4)'!$B$41=1,30,20),'Data entry (4)'!$B$43),0)*'Data entry (4)'!$B$8*30/10^3","v":48},584]
["Rainfall (m)",{"$f":"VLOOKUP('Data entry (4)'!B6,rainfall,14,FALSE)/1000","v":0.68300000000000005},{"$f":"VLOOKUP('Data entry (4)'!$B$6,rainfall,MATCH(C5,Rainfall!$A$3:$M$3,0),FALSE)/1000","v":5.8000000000000003E-2},{"$f":"VLOOKUP('Data entry (4)'!$B$6,rainfall,MATCH(D5,Rainfall!$A$3:$M$3,0),FALSE)/1000","v":6.9000000000000006E-2},{"$f":"VLOOKUP('Data entry (4)'!$B$6,rainfall,MATCH(E5,Rainfall!$A$3:$M$3,0),FALSE)/1000","v":7.0999999999999994E-2},{"$f":"VLOOKUP('Data entry (4)'!$B$6,rainfall,MATCH(F5,Rainfall!$A$3:$M$3,0),FALSE)/1000","v":6.2E-2},{"$f":"VLOOKUP('Data entry (4)'!$B$6,rainfall,MATCH(G5,Rainfall!$A$3:$M$3,0),FALSE)/1000","v":4.4999999999999998E-2},{"$f":"VLOOKUP('Data entry (4)'!$B$6,rainfall,MATCH(H5,Rainfall!$A$3:$M$3,0),FALSE)/1000","v":5.3999999999999999E-2},{"$f":"VLOOKUP('Data entry (4)'!$B$6,rainfall,MATCH(I5,Rainfall!$A$3:$M$3,0),FALSE)/1000","v":0.05},{"$f":"VLOOKUP('Data entry (4)'!$B$6,rainfall,MATCH(J5,Rainfall!$A$3:$M$3,0),FALSE)/1000","v":5.2999999999999999E-2},{"$f":"VLOOKUP('Data entry (4)'!$B$6,rainfall,MATCH(K5,Rainfall!$A$3:$M$3,0),FALSE)/1000","v":5.1999999999999998E-2},{"$f":"VLOOKUP('Data entry (4)'!$B$6,rainfall,MATCH(L5,Rainfall!$A$3:$M$3,0),FALSE)/1000","v":5.1999999999999998E-2},{"$f":"VLOOKUP('Data entry (4)'!$B$6,rainfall,MATCH(M5,Rainfall!$A$3:$M$3,0),FALSE)/1000","v":6.3E-2},{"$f":"VLOOKUP('Data entry (4)'!$B$6,rainfall,MATCH(N5,Rainfall!$A$3:$M$3,0),FALSE)/1000","v":5.3999999999999999E-2},0.68300000000000005]
["Yard run off area to slurry store",{"$f":"'Data entry (4)'!D60","v":0},{"$f":"$B$13*C12","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Slurry store area",{"$f":"'Data entry (4)'!G29","v":0},{"$f":"$B$14*C12","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Roof water area to store",{"$f":"'Data entry (4)'!D75","v":0},{"$f":"$B$15*C12","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Total cubic metres",null,{"$f":"C9-C10+C11+C13+C14+C15","v":49.6},{"$f":"D9-D10+D11+D13+D14+D15","v":48},49.6,49.6,44.8,49.6,48,49.6,48,49.6,49.6,48,{"$f":"O9-O10+O11+O13+O14+O15","v":584}]
["Cumulative production",null,{"$f":"C16","v":49.6},{"$f":"C17+D16","v":97.6},147.19999999999999,196.79999999999998,241.59999999999997,291.2,339.2,388.8,436.8,486.40000000000003,536,584]
["Total storage capacity",{"$f":"'Data entry (4)'!F29","v":0},{"$f":"B18","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Capacity less production",null,{"$f":"C18-C17","v":-49.6},-97.6,-147.19999999999999,-196.79999999999998,-241.59999999999997,-291.2,-339.2,-388.8,-436.8,-486.40000000000003,-536,-584]
[]
["Cost/Benefits","Net Benefit £/year",{"$nulls":4},"Action points"]
["Divert roof water",{"$f":"(O15*'Data entry (4)'!B14)+((SUM(C15:G15)*'Data entry (4)'!B18)*('Data entry (4)'!B9/100+'Data entry (4)'!B11/100))-((B15*'Data entry (4)'!B16)*('Data entry (4)'!B9/100+'Data entry (4)'!B11/100))","v":0},{"$nulls":4},{"$f":"IF($G$19<0,\"You do not have enough slurry storage\",\"\")","v":"You do not have enough slurry storage"}]
["Divert roof water & harvest",{"$f":"B22+(O15*'Data entry (4)'!B13)-((O15*'Data entry (4)'!B15)*('Data entry (4)'!B9/100+'Data entry (4)'!B11/100))","v":0},{"$nulls":4},{"$f":"IF(AND($G$19<0,$B$11=\"yes\"),\"Consider diverting parlour washings to a separate store\",\"\")","v":"Consider diverting parlour washings to a separate store"}]
["Roof dirty yard",{"$f":"(O13*'Data entry (4)'!B14)+((SUM(C13:G13)*'Data entry (4)'!B18)*('Data entry (4)'!B9/100+'Data entry (4)'!B11/100))-((B13*'Data entry (4)'!B17)*('Data entry (4)'!B9/100+'Data entry (4)'!B11/100))","v":0},{"$nulls":4},{"$f":"IF(AND($G$19<0,$B$15>0),\"Consider collecting roof water or diverting to a clean drain\",\"\")","v":""}]
["Roof dirty yard & harvest water",{"$f":"B24+(O13*'Data entry (4)'!B13)-((O13*'Data entry (4)'!B15)*('Data entry (4)'!B9/100+'Data entry (4)'!B11/100))","v":0},{"$nulls":4},{"$f":"IF(AND($G$19<0,$B$10=\"no\"),\"Consider slurry separation ~ see slurry strategies booklet\",\"\")","v":"Consider slurry separation ~ see slurry strategies booklet"}]
[]
[{"$f":" CONCATENATE(\"The cost/benefit is based on a slurry storage cost of £\",'Data entry (4)'!B18,\"/cubic metre\")","v":"The cost/benefit is based on a slurry storage cost of £35/cubic metre"}]

{"sheet":"Rainfall","index":13,"n_rows":617,"n_cols":15,"rows_kept":617,"cut":false,"hidden":true,"merged":[]}
["MANNER rainfall data"]
[]
["STD ","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total","Manner total"]
["0113",77,61,67,62,59,61,59,72,71,73,77,78,{"$f":"SUM(B4:M4)","v":817},815]
["0114",92,70,77,69,65,62,54,66,67,74,87,92,875,875]
["0115",53,46,48,48,50,55,48,59,49,50,54,59,619,620]
["0116",53,45,49,50,52,60,47,61,50,50,55,59,631,630]
["0117",85,61,68,55,64,65,61,74,82,83,85,92,875,875]
["0118",69,48,58,49,54,53,43,56,60,63,68,74,695,695]
["01200",131,79,102,78,81,96,94,124,129,147,139,137,1337,1337]
["01202",93,67,70,49,54,52,42,55,70,87,90,95,824,823]
["01204",129,84,103,80,86,97,96,125,124,142,137,137,1340,1338]
["01205",51,39,47,47,50,54,46,59,48,46,56,52,595,594]
["01206",48,33,43,40,43,47,44,47,48,49,56,51,549,548]
["01207",72,49,57,52,60,56,57,76,62,59,69,65,734,732]
["01208",112,78,82,55,56,59,59,74,81,100,111,111,978,978]
["01209",136,103,100,64,67,64,61,74,85,113,126,137,1130,1129]
["0121",71,54,64,60,66,61,54,72,65,65,68,79,779,780]
["01223",44,32,41,43,48,48,47,53,46,47,50,49,548,547]
["01224",83,53,58,53,62,53,65,75,69,77,73,71,792,791]
["01225",94,69,78,59,69,63,62,73,82,81,90,102,922,921]
["01226",78,62,66,63,58,58,48,61,58,63,76,79,770,769]
["01227",65,45,52,48,45,48,50,53,61,71,75,66,679,679]
["01228",73,44,58,43,55,60,66,78,83,82,76,68,786,784]
["01229",97,65,81,61,61,64,73,96,100,116,104,102,1020,1020]
["01233",77,50,58,49,49,49,49,51,64,80,84,74,734,735]
["01234",45,35,46,46,48,50,46,53,47,51,51,54,572,571]
["01235",70,50,62,49,57,57,46,62,62,64,69,76,724,725]
["01236",111,74,91,58,68,67,69,97,116,119,115,106,1091,1091]
["01237",113,79,84,61,61,65,69,83,98,115,123,119,1070,1070]
["01239",138,91,98,75,73,73,67,90,107,143,136,147,1238,1236]
["01241",84,57,64,53,64,59,64,78,77,79,72,72,823,822]
["01242",67,52,59,52,61,62,54,67,66,61,65,78,744,742]
["01243",75,52,60,50,49,46,43,53,64,76,80,77,725,725]
["01244",63,49,55,50,57,54,46,56,59,62,79,73,703,703]
["01245",54,37,48,45,46,50,50,54,51,54,58,57,604,603]
["01246",111,81,89,75,74,74,64,81,84,94,104,110,1041,1039]
["01248",109,74,87,63,65,67,76,97,101,125,130,124,1118,1117]
["01249",67,50,59,48,58,56,51,60,66,63,65,76,719,719]
["01250",84,58,62,43,63,62,66,78,80,82,71,76,825,825]
["01252",73,49,60,51,58,50,48,54,64,69,72,76,724,722]
["01253",79,54,64,50,51,59,59,78,87,95,91,88,855,854]
["01254",108,68,88,73,77,87,83,107,112,123,116,114,1156,1155]
["01255",51,35,45,42,43,46,45,48,49,50,58,53,565,565]
["01256",93,62,74,56,64,61,57,66,78,85,90,97,883,881]
["01257",91,61,77,61,65,75,72,94,94,107,102,99,998,997]
["01258",113,83,85,59,66,57,50,69,86,102,105,116,991,991]
["01259",102,70,82,52,66,67,72,90,107,103,103,103,1017,1016]
["01260",69,48,58,54,63,69,61,72,70,71,76,71,782,781]
["01261",64,45,55,44,51,53,61,79,71,70,78,67,738,737]
["01262",62,45,54,50,53,52,52,63,54,58,69,71,683,682]
["01263",58,41,48,48,44,50,56,56,53,60,70,62,646,645]
["01264",85,57,68,49,58,55,45,63,64,73,77,88,782,781]
["01267",162,109,118,89,87,89,82,114,130,166,158,168,1472,1470]
["01268",52,35,45,45,48,49,47,47,55,53,57,55,588,584]
["01269",161,107,117,87,89,95,89,121,135,161,157,167,1486,1486]
["01270",57,43,50,48,61,56,50,59,59,62,70,67,682,683]
["01271",151,102,105,77,77,84,84,99,117,144,154,157,1351,1350]
["01273",84,56,66,54,51,56,51,60,71,92,97,87,825,823]
["01274",100,78,84,72,65,64,58,79,84,92,99,104,979,978]
["01275",85,61,68,55,64,65,61,74,82,83,85,92,875,874]
["01276",62,43,54,48,56,51,48,53,59,62,63,66,665,666]
["01277",54,37,47,45,49,51,50,52,55,55,58,57,610,610]
["01278",81,63,61,50,56,51,48,61,61,72,74,83,761,760]
["01279",57,40,50,48,49,53,51,56,54,58,59,61,636,636]
["01280",60,45,57,47,57,56,51,59,55,58,58,67,670,669]
["01282",123,78,97,77,78,86,84,109,114,128,124,131,1229,1226]
["01283",66,51,56,53,59,59,53,69,63,62,67,74,{"$f":"SUM(B68:M68)","v":732},731]
["01284",49,34,44,45,46,51,48,51,51,52,57,54,582,581]
["01285",78,58,67,53,65,63,56,68,69,69,74,88,808,807]
["01286",218,148,174,117,117,129,136,181,193,241,241,246,2141,2140]
["01287",78,57,69,62,63,64,66,81,74,73,92,83,862,861]
["01288",119,79,86,61,61,68,72,82,92,109,124,119,1072,1072]
["01289",57,40,47,44,52,55,56,67,57,61,60,54,650,648]
["01290",130,81,101,63,75,74,87,112,136,146,135,127,1267,1266]
["01291",112,85,85,65,70,70,67,83,95,103,105,119,1059,1058]
["01292",121,77,95,59,65,68,82,104,131,137,131,120,1190,1190]
["01293",95,62,73,64,64,62,53,66,83,92,95,98,907,906]
["01294",105,69,83,56,63,63,74,98,120,120,112,103,1066,1065]
["01295",61,47,58,47,57,60,52,65,57,58,59,69,690,690]
["01296",62,44,56,51,57,57,52,62,57,61,62,69,690,689]
["01297",107,83,81,58,63,58,56,69,73,89,92,105,934,933]
["01298",132,93,106,85,84,82,78,97,100,113,124,132,1226,1225]
["01299",72,56,63,57,64,58,56,68,67,66,71,81,779,778]
["01300",118,87,89,62,71,60,55,75,88,102,106,120,1033,1032]
["01301",370,251,296,161,171,171,199,246,323,355,325,360,3228,3226]
["01302",50,41,47,50,52,56,51,57,50,47,54,54,609,608]
["01303",76,50,60,53,50,53,55,52,69,84,95,76,773,772]
["01304",77,53,63,55,49,56,54,57,73,91,106,79,813,813]
["01305",89,67,71,50,51,47,44,58,66,82,87,92,804,802]
["01306",89,57,68,60,63,57,52,64,76,84,84,90,844,843]
["01307",87,57,61,47,61,59,63,73,75,75,67,72,797,797]
["01308",100,74,75,55,60,50,52,67,71,89,91,98,882,879]
["01309",51,37,45,36,45,53,59,73,62,59,63,52,635,634]
["0131",59,43,53,43,54,52,57,64,65,67,64,57,678,677]
["01320",252,179,233,112,122,119,121,151,217,264,266,275,2311,2309]
["01322",59,39,49,47,51,49,46,50,57,58,59,61,625,625]
["01323",81,54,62,51,47,55,47,56,70,89,94,83,789,790]
["01324",119,78,101,59,69,71,75,102,125,120,126,121,1166,1164]
["01325",62,45,53,51,53,54,52,68,52,55,61,57,663,663]
["01326",119,93,87,57,57,54,53,65,74,97,109,114,979,978]
["01327",58,44,55,47,55,57,53,65,53,57,58,67,669,668]
["01328",62,43,53,51,53,55,59,63,56,60,74,65,694,694]
["01329",86,57,63,49,52,48,42,56,65,80,86,84,768,766]
["01330",102,63,69,56,65,60,72,77,74,86,80,85,889,886]
["01332",61,50,53,50,53,59,52,61,56,58,61,67,681,681]
["01333",71,52,60,49,59,58,63,75,74,73,73,69,776,774]
["01334",72,50,57,48,59,56,60,70,70,70,68,66,746,745]
["01335",89,65,72,63,68,73,64,80,76,79,88,93,910,909]
["01337",92,63,73,50,63,65,64,74,82,86,86,87,885,884]
["013397",101,59,69,58,67,62,70,77,78,88,84,86,899,898]
["013398",101,59,69,58,67,62,70,77,78,88,84,86,899,898]
["01340",75,55,70,60,69,67,76,90,80,85,90,79,896,896]
["01341",174,119,144,101,99,108,121,140,153,187,199,208,1753,1751]
["01342",93,61,72,62,62,63,54,66,84,91,96,95,899,898]
["01343",55,40,49,39,48,53,60,75,62,61,66,55,663,662]
["01344",67,46,57,50,58,53,49,55,63,66,67,71,702,699]
["01346",70,47,57,44,50,51,58,73,71,71,79,72,743,742]
["01347",56,42,47,44,50,53,50,63,53,51,53,56,618,617]
["01348",109,74,80,62,59,64,60,87,96,118,120,132,1061,1060]
["01349",83,59,71,42,55,56,52,66,69,84,91,84,812,812]
["01350",137,91,99,60,84,79,83,99,116,128,116,128,1220,1218]
["01352",71,54,64,57,61,57,55,64,70,74,90,84,801,800]
["01353",44,33,43,42,50,53,47,54,45,47,52,49,559,559]
["01354",45,33,44,43,51,52,49,56,46,45,52,50,566,564]
["01355",143,92,118,72,81,82,92,125,157,156,152,142,1412,1413]
["01356",109,72,76,56,73,62,67,78,84,94,84,88,943,942]
["01357",141,89,117,73,80,86,96,127,151,155,155,143,1413,1412]
["01358",79,50,59,54,60,54,63,75,71,77,78,72,792,790]
["01359",49,34,43,43,45,50,48,49,50,52,57,52,572,570]
["01360",150,102,126,75,90,85,91,122,155,159,150,147,1452,1451]
["01361",78,54,65,54,64,62,64,79,75,75,79,72,{"$f":"SUM(B132:M132)","v":821},820]
["01362",61,43,52,51,52,55,57,60,56,60,73,64,684,683]
["01363",133,96,91,65,66,58,54,71,78,105,115,130,1062,1062]
["01364",191,147,139,91,89,85,78,103,113,144,161,187,1528,1528]
["01366",48,35,45,43,51,55,50,55,47,50,57,52,588,587]
["01367",60,44,55,46,55,54,44,55,55,58,59,67,652,650]
["01368",70,45,62,51,62,56,59,78,68,73,77,66,767,765]
["01369",179,114,142,85,94,98,113,142,189,185,174,172,1687,1686]
["01371",52,37,48,45,45,49,51,54,50,54,58,57,600,599]
["01372",60,39,50,46,52,49,44,54,56,62,61,63,636,636]
["01373",99,74,82,61,69,64,62,77,80,82,94,104,948,947]
["01375",58,39,48,47,50,49,47,48,58,57,60,61,622,621]
["01376",49,34,45,44,44,51,45,50,48,52,55,52,569,568]
["01377",59,44,56,52,55,55,56,68,57,58,65,66,691,691]
["01379",48,34,41,41,45,50,47,47,48,53,57,52,563,562]
["01380",77,57,66,51,60,56,50,66,69,70,75,86,783,782]
["01381",67,49,57,40,55,59,60,75,69,74,77,69,751,750]
["01382",73,49,56,44,56,56,58,67,70,69,64,67,729,729]
["01383",67,49,57,43,52,53,59,72,77,73,74,68,744,743]
["01384",68,52,58,55,62,58,57,68,65,63,66,76,748,745]
["01386",63,47,54,49,58,56,52,68,61,55,61,72,696,694]
["01387",108,75,82,55,70,65,72,94,104,116,101,105,1047,1046]
["01388",65,47,55,51,56,55,57,70,58,58,65,63,700,701]
["01389",178,119,145,82,95,87,95,127,168,180,174,176,1626,1627]
["01392",104,81,70,53,59,50,43,58,61,82,80,99,840,839]
["01394",53,37,46,44,44,46,48,47,53,54,61,54,587,587]
["01395",96,77,69,51,55,48,46,59,61,78,77,94,811,811]
["01397",250,174,218,108,114,132,150,173,239,269,248,258,2333,2331]
["01398",140,101,103,78,82,74,76,93,103,120,130,142,1242,1241]
["01400",53,42,49,51,54,53,46,61,48,47,55,54,613,613]
["01403",97,63,74,62,61,59,48,64,79,91,95,98,891,891]
["01404",118,90,86,64,70,64,63,74,82,97,97,116,1021,1021]
["01405",48,36,48,48,50,54,53,62,51,48,54,54,606,606]
["01406",49,36,46,46,52,52,49,58,48,45,56,52,589,588]
["01407",81,55,63,53,49,51,53,72,73,88,96,92,826,825]
["01408",80,53,66,45,56,57,58,74,73,78,88,75,803,802]
["01409",133,89,91,65,67,71,77,88,97,116,130,136,1160,1160]
["0141",130,85,105,60,76,68,69,99,131,138,129,124,1214,1214]
["01420",92,62,73,56,63,56,55,61,74,83,89,95,859,856]
["01422",127,92,108,88,80,82,78,107,114,124,134,136,1270,1270]
["01423",68,53,57,53,53,52,51,65,58,60,64,66,700,699]
["01424",88,57,65,53,50,55,52,60,72,94,100,87,833,833]
["01425",91,64,68,50,58,56,43,58,68,83,86,93,818,818]
["01427",48,38,47,51,52,56,53,59,50,47,54,54,609,608]
["01428",100,65,76,60,65,59,55,64,79,90,94,99,906,905]
["01429",55,41,52,48,52,54,55,67,55,56,71,59,665,664]
["014304",51,39,50,46,51,53,54,65,51,51,56,57,624,623]
["014308",51,39,50,46,51,53,54,65,51,51,56,57,624,623]
["01431",74,48,59,40,52,56,61,78,75,72,83,67,765,767]
["01432",82,60,62,51,60,53,44,60,65,67,70,79,753,753]
["01433",132,92,106,83,79,84,79,100,103,115,123,131,1227,1226]
["014342",127,91,102,73,71,68,77,97,97,105,123,114,1145,1144]
["014343",127,91,102,73,71,68,77,97,97,105,123,114,1145,1144]
["014346",127,91,102,73,71,68,77,97,97,105,123,114,1145,1144]
["014348",127,91,102,73,71,68,77,97,97,105,123,114,1145,1144]
["01435",88,58,66,54,53,61,51,63,74,93,95,88,844,842]
["01436",194,124,151,87,95,95,106,135,187,189,179,182,1724,1723]
["01437",101,72,76,57,54,57,50,75,83,107,109,115,956,956]
["01438",58,43,52,51,50,57,48,55,55,62,60,63,654,654]
["01439",71,50,62,50,57,60,60,70,66,68,70,72,756,756]
["01440",50,36,46,45,47,49,51,54,51,52,57,56,594,593]
["01442",78,55,67,58,63,66,58,72,68,74,76,84,819,819]
["01443",235,156,166,117,119,118,115,154,173,207,211,236,2007,2005]
["01444",98,63,73,63,61,63,51,65,83,96,99,99,914,915]
["01445",181,129,173,101,95,111,126,138,214,225,232,222,{"$f":"SUM(B196:M196)","v":1947},1945]
["01446",104,74,81,59,65,69,70,85,94,104,105,107,1017,1015]
["01449",51,36,44,44,45,47,49,48,50,55,59,52,580,579]
["01450",102,68,80,55,72,66,78,88,87,98,99,101,994,993]
["01451",73,55,64,52,63,62,55,68,66,66,70,83,777,775]
["01452",70,51,56,48,59,53,52,65,65,62,66,76,723,723]
["01453",79,58,64,53,65,60,58,71,73,72,75,87,815,814]
["01454",79,59,63,52,63,63,56,67,74,76,78,88,818,818]
["01455",55,45,50,49,53,60,49,65,52,51,56,61,646,644]
["01456",138,99,118,62,79,67,70,89,110,140,145,145,1262,1261]
["01457",80,56,69,54,64,74,73,88,84,89,86,88,905,906]
["01458",69,53,52,43,54,49,51,61,59,63,67,73,694,694]
["01460",119,87,86,62,68,59,58,73,80,97,100,116,1005,1003]
["01461",80,55,67,49,62,65,70,87,93,93,84,81,886,884]
["01462",52,38,47,48,48,53,47,55,51,57,55,57,608,606]
["01463",98,72,86,49,65,59,63,75,85,103,110,105,970,970]
["01464",87,57,69,63,66,61,70,80,78,88,91,83,893,892]
["01465",144,89,109,74,73,79,95,112,141,149,145,137,1347,1345]
["01466",79,54,68,60,64,61,72,83,78,84,91,79,873,872]
["01467",86,53,61,54,60,55,64,74,68,79,77,75,806,806]
["01469",57,42,53,52,51,53,52,65,54,53,62,62,656,656]
["01470",209,133,180,83,87,104,118,132,192,233,217,213,1901,1898]
["01471",324,207,285,146,139,161,188,222,325,355,350,338,3040,3039]
["01472",59,44,54,54,50,52,49,62,52,52,63,61,652,651]
["01473",52,36,46,43,44,46,46,47,50,52,59,53,574,572]
["01474",75,50,59,54,55,55,53,56,70,70,75,78,750,750]
["01475",123,75,92,62,64,70,78,103,130,136,124,118,1175,1174]
["01476",52,42,49,53,53,54,48,62,49,48,54,55,619,619]
["01477",61,44,53,50,63,62,55,66,64,66,72,67,723,723]
["01478",244,160,219,106,108,128,142,162,241,282,272,267,2331,2330]
["01479",117,75,91,64,79,77,86,103,99,115,111,103,1120,1118]
["01480",44,34,43,45,47,51,43,53,45,47,49,50,551,549]
["01482",55,41,53,51,52,53,52,67,54,53,61,62,654,653]
["01483",68,45,56,49,56,49,45,51,60,64,66,70,679,678]
["01484",120,88,106,88,75,78,73,99,100,116,131,126,1200,1200]
["01485",53,38,49,45,52,56,52,59,50,51,64,58,627,626]
["01487",45,35,44,46,49,50,46,53,44,45,50,49,556,555]
["01488",82,58,72,55,61,61,50,69,68,73,79,88,816,815]
["01489",86,59,67,50,55,52,44,59,70,80,85,88,795,793]
["01490",146,100,108,79,79,68,69,90,113,130,146,158,1286,1284]
["01491",68,48,60,51,57,60,48,66,63,66,67,77,731,730]
["01492",224,146,172,123,124,113,106,144,164,221,241,246,2024,2022]
["01493",55,40,43,47,44,46,51,55,54,58,67,59,619,618]
["01494",76,53,66,56,62,65,55,70,68,73,75,82,801,799]
["01495",163,116,117,87,93,81,75,103,127,142,138,164,1406,1405]
["01496",115,75,89,56,57,61,76,80,117,130,116,107,1079,1079]
["01497",123,84,92,66,74,64,62,81,95,103,110,125,1079,1076]
["01499",321,213,258,141,143,149,170,215,297,319,297,315,2838,2838]
["01501",91,61,75,51,62,62,66,90,99,97,93,89,936,933]
["01502",54,40,43,47,44,47,51,51,53,57,64,58,609,608]
["01503",152,111,108,70,71,70,70,86,98,123,135,152,1246,1244]
["01505",149,98,123,76,85,87,102,133,174,173,150,147,1497,1495]
["01506",78,53,65,44,54,52,57,76,82,84,84,78,807,806]
["01507",60,45,55,55,51,53,47,61,50,51,64,60,652,651]
["01508",55,40,46,48,47,52,50,52,51,57,63,59,620,620]
["01509",54,46,49,49,52,57,47,62,50,49,55,60,630,629]
["0151",66,48,56,52,56,61,57,71,75,80,80,73,775,773]
["01520",234,163,218,123,119,137,153,174,254,276,276,275,2402,2401]
["01522",47,38,47,48,49,53,48,57,45,44,52,52,580,578]
["01524",92,60,76,58,62,65,73,94,104,110,103,100,997,997]
["01525",56,41,54,51,55,54,54,59,55,59,60,64,662,663]
["01526",51,39,48,46,49,53,48,59,47,46,55,53,594,592]
["01527",61,46,53,49,57,56,51,64,59,55,58,68,677,678]
["01528",190,130,160,76,97,87,90,112,158,195,187,185,1667,1666]
["01529",52,41,49,52,54,53,46,61,48,47,54,53,{"$f":"SUM(B260:M260)","v":610},609]
["01530",61,50,54,53,57,60,51,67,58,57,62,68,698,698]
["01531",67,51,53,46,57,53,48,60,64,60,61,72,692,690]
["01535",130,94,106,86,80,79,74,104,111,123,129,136,1252,1251]
["01536",57,44,53,52,55,56,52,66,53,53,57,63,661,660]
["01538",85,62,72,64,69,73,67,84,78,80,89,92,915,913]
["01539",122,79,100,75,75,83,93,117,126,140,125,121,1256,1256]
["015394",122,79,100,75,75,83,93,117,126,140,125,121,1256,1256]
["015395",122,79,100,75,75,83,93,117,126,140,125,121,1256,1256]
["015396",122,79,100,75,75,83,93,117,126,140,125,121,1256,1256]
["01540",164,110,132,73,86,83,88,106,125,152,150,150,1419,1417]
["01542",71,50,64,52,59,60,76,89,78,82,88,71,840,839]
["01543",64,50,55,54,59,57,53,68,62,60,64,72,718,715]
["01544",107,78,82,63,70,61,56,75,85,91,97,108,973,970]
["01545",105,70,76,63,63,68,67,83,97,118,110,113,1033,1034]
["01546",203,130,165,96,98,107,134,162,208,220,208,201,1932,1931]
["01547",115,88,91,72,78,66,58,81,90,98,106,119,1062,1061]
["01548",114,93,88,58,60,60,60,70,75,91,103,113,985,984]
["01549",151,107,132,80,77,80,75,94,125,154,170,162,1407,1406]
["01550",178,118,129,92,97,90,89,117,137,168,170,187,1572,1572]
["01553",53,38,49,46,53,56,52,59,50,51,64,57,628,627]
["01554",133,91,97,76,77,83,76,103,117,144,136,139,1272,1270]
["01555",110,71,89,55,68,66,71,95,108,117,115,109,1074,1072]
["01556",138,93,107,71,74,74,77,106,130,143,133,134,1280,1277]
["01557",122,82,95,70,69,75,79,108,123,132,118,118,1191,1191]
["01558",190,124,137,95,100,97,94,129,145,176,177,194,1658,1659]
["01559",164,109,119,89,87,90,85,114,132,167,159,170,1485,1483]
["01560",118,75,98,63,72,75,90,118,147,138,129,119,1242,1240]
["01561",98,63,70,57,72,57,68,77,78,87,83,81,891,890]
["01562",65,50,56,52,60,55,53,63,62,59,63,73,711,711]
["01563",93,60,77,50,60,62,76,98,119,113,105,95,1008,1007]
["01564",68,54,61,55,61,62,55,76,63,62,66,76,759,758]
["01565",67,48,57,52,64,65,59,74,68,72,77,72,775,773]
["01566",176,116,119,79,83,83,92,104,114,145,158,172,1441,1440]
["01567",284,190,219,110,135,116,125,160,222,253,243,269,2326,2327]
["01568",79,59,64,52,59,54,48,63,70,71,72,85,776,775]
["01569",101,64,71,62,74,60,72,82,79,89,87,84,925,924]
["01570",141,91,101,78,80,82,82,104,121,144,140,149,1313,1313]
["01571",107,74,98,60,53,70,76,90,131,134,139,117,1149,1147]
["01572",57,45,54,55,53,56,53,67,54,56,59,63,672,671]
["01573",66,48,54,44,60,56,64,74,66,66,65,65,728,729]
["01575",95,64,69,49,65,64,68,83,87,84,77,82,887,887]
["01576",113,79,89,62,79,77,85,108,116,121,105,110,1144,1142]
["01577",91,64,74,52,64,67,73,92,102,95,95,92,961,961]
["01578",87,63,71,53,69,62,68,82,81,81,76,79,872,871]
["01579",170,122,119,78,83,80,83,99,110,138,149,170,1401,1399]
["01580",86,57,65,54,53,56,50,58,71,88,90,85,813,811]
["01581",133,83,100,72,69,77,80,108,129,139,131,127,1248,1246]
["01582",71,50,62,58,59,61,54,60,63,71,70,76,755,754]
["01583",153,95,115,72,71,79,93,109,145,161,150,137,1380,1377]
["01584",78,58,66,56,62,57,52,69,71,70,72,85,796,794]
["01586",134,83,100,63,62,67,81,92,127,142,132,118,1201,1200]
["01588",100,75,79,67,70,59,51,70,80,83,91,102,927,927]
["01590",88,61,68,51,57,54,44,59,71,82,87,89,811,811]
["01591",183,121,134,99,102,96,99,124,147,174,179,199,1657,1656]
["01592",75,55,64,49,57,61,64,77,84,79,80,74,819,818]
["01593",85,56,67,46,54,60,65,85,88,83,98,81,868,867]
["01594",109,82,81,63,72,67,61,77,90,96,95,112,1005,1004]
["01597",192,136,140,104,97,90,80,110,136,161,178,204,1628,1627]
["01598",173,116,120,89,89,97,99,120,135,160,172,181,1551,1550]
["01599",220,152,201,106,104,120,131,155,219,247,241,240,2136,2134]
["01600",117,85,84,65,71,59,50,70,85,94,96,112,988,986]
["01603",57,42,48,49,45,51,55,55,52,59,67,61,641,639]
["01604",53,41,51,47,53,54,50,60,50,53,55,62,629,628]
["01606",63,46,54,53,62,62,58,70,65,70,76,70,{"$f":"SUM(B324:M324)","v":749},749]
["01608",68,51,62,51,60,62,52,65,61,63,64,75,734,733]
["01609",55,42,48,47,49,51,48,61,47,49,54,52,603,602]
["0161",72,53,62,52,61,68,65,79,77,82,81,81,833,832]
["01620",44,31,41,36,47,47,54,67,58,56,55,46,582,580]
["01621",46,32,42,40,42,48,44,47,48,49,53,49,540,539]
["01622",76,51,58,51,51,51,46,51,64,76,79,77,731,729]
["01623",71,58,64,60,58,61,55,62,61,66,71,76,763,763]
["01624",146,96,109,86,76,84,84,111,126,150,143,145,1356,1355]
["01625",76,53,63,55,67,71,67,80,77,79,83,80,851,849]
["01626",171,132,120,81,81,66,56,82,90,124,134,165,1302,1301]
["01628",62,43,56,49,56,56,48,60,61,63,64,69,687,685]
["01629",105,77,84,72,71,73,63,78,79,88,99,105,994,992]
["01630",60,46,53,50,61,56,53,61,59,61,68,70,698,696]
["01631",259,168,211,110,115,120,144,174,253,283,248,260,2345,2344]
["01633",103,78,82,63,65,67,64,82,92,99,104,111,1010,1009]
["01634",75,50,59,54,55,55,53,56,70,70,75,78,750,750]
["01635",81,56,69,53,58,59,45,65,64,69,78,87,784,782]
["01636",48,42,47,49,48,53,46,56,45,45,51,53,583,581]
["01637",108,78,76,52,54,57,54,66,76,95,104,111,931,931]
["01638",46,34,43,44,48,51,47,53,49,49,53,52,569,567]
["01639",162,107,120,84,93,94,94,126,134,155,162,171,1502,1500]
["01641",117,82,101,60,58,67,68,93,114,125,142,119,1146,1145]
["01642",47,33,43,43,47,50,51,61,49,46,54,48,572,572]
["01643",142,104,104,76,79,70,67,89,101,119,124,146,1221,1220]
["01644",208,133,151,94,98,94,98,134,172,196,187,192,1757,1755]
["01646",96,71,74,55,52,55,47,72,79,105,104,105,915,913]
["01647",229,167,159,105,98,83,74,104,123,170,189,231,1732,1729]
["01650",236,161,188,123,118,120,126,163,184,224,253,279,2175,2173]
["01651",83,52,62,56,60,56,64,74,70,80,81,75,813,811]
["01652",56,41,52,50,49,53,54,63,53,53,60,60,644,644]
["01653",60,45,56,46,56,55,57,65,61,60,62,66,689,688]
["01654",157,107,131,92,93,101,113,132,142,169,182,188,1607,1606]
["01655",131,83,100,64,67,70,86,103,132,134,132,123,1225,1224]
["01656",119,80,87,66,73,77,78,99,108,123,125,127,1162,1161]
["01659",181,121,133,79,99,89,91,123,149,171,161,170,1567,1567]
["01661",60,42,53,45,52,49,53,70,55,52,63,54,648,647]
["01663",81,56,70,59,67,75,74,88,85,90,89,90,924,923]
["01664",54,45,51,53,53,58,53,65,53,55,57,60,657,658]
["01665",83,59,70,55,62,55,62,79,68,69,88,77,827,826]
["01666",76,57,65,52,65,63,60,68,74,71,75,87,813,812]
["01667",55,40,49,37,50,57,59,72,64,64,69,60,676,676]
["01668",79,55,69,57,62,57,61,77,64,72,85,73,811,810]
["01669",88,64,76,57,63,58,64,81,72,72,92,83,870,869]
["01670",56,40,51,44,49,48,56,68,58,49,62,55,636,637]
["01671",178,116,138,93,87,98,101,144,168,178,166,165,1632,1633]
["01672",81,57,70,54,61,60,53,69,70,75,76,88,814,812]
["01673",55,42,52,49,50,53,52,60,51,51,58,58,631,630]
["01674",86,56,61,47,63,51,59,68,70,77,69,70,777,775]
["01675",66,53,58,55,60,59,50,71,59,58,64,73,726,724]
["01676",65,54,57,53,58,62,54,74,60,59,65,72,733,731]
["01677",82,64,69,60,58,54,51,68,60,69,79,80,794,793]
["01678",208,145,156,107,104,92,94,122,157,195,207,225,1812,1811]
["01680",244,152,193,108,111,120,146,171,238,264,235,243,2225,2223]
["01681",139,84,107,65,64,69,90,99,140,151,137,138,1283,1281]
["01683",192,129,146,92,108,95,105,136,179,182,166,177,1707,1708]
["01684",62,48,51,45,55,51,47,59,62,55,57,69,661,659]
["01685",257,171,179,126,128,121,118,159,182,221,226,260,2148,2147]
["01686",97,72,76,58,66,54,51,68,76,82,92,101,893,894]
["01687",186,123,166,97,94,110,134,154,211,218,212,200,1905,1905]
["01688",170,99,128,77,76,84,110,124,166,179,163,165,1541,1540]
["01689",72,47,59,55,57,55,51,59,68,70,72,75,740,739]
["01690",278,184,229,154,148,168,167,230,248,286,310,315,2717,2716]
["01691",92,69,78,61,67,62,62,77,83,83,99,100,933,932]
["01692",57,41,48,48,44,50,55,57,51,60,68,61,{"$f":"SUM(B388:M388)","v":640},638]
["01694",87,64,71,61,67,62,60,71,83,80,82,91,879,879]
["01695",77,54,65,56,59,67,65,83,84,93,90,85,878,877]
["016973",92,60,75,55,63,71,82,96,98,96,91,84,963,963]
["016974",92,60,75,55,63,71,82,96,98,96,91,84,963,963]
["016977",92,60,75,55,63,71,82,96,98,96,91,84,963,963]
["016978",92,60,75,55,63,71,82,96,98,96,91,84,963,963]
["01698",112,73,92,56,66,66,68,94,113,121,119,108,1088,1088]
["01700",154,97,122,74,78,83,96,122,163,167,158,150,1464,1462]
["01702",51,34,45,45,46,49,46,47,56,53,58,54,584,584]
["01704",73,50,61,51,53,62,60,77,82,89,86,81,825,823]
["01706",129,86,104,78,85,93,91,120,125,137,135,136,1319,1319]
["01707",65,46,57,53,57,59,53,57,60,67,66,70,710,710]
["01708",51,35,45,44,50,49,47,50,54,54,55,55,589,585]
["01709",63,52,57,55,54,60,52,57,55,55,64,66,690,691]
["01721",108,74,90,63,73,75,81,100,105,110,106,102,1087,1085]
["01722",88,64,72,53,63,58,49,69,71,78,85,96,846,846]
["01723",64,46,56,49,52,51,53,59,56,59,71,71,687,687]
["01724",49,36,49,48,48,53,52,63,52,49,55,55,609,610]
["01725",95,69,73,52,62,57,46,64,73,86,89,99,865,864]
["01726",146,106,105,68,68,68,68,84,97,121,133,145,1209,1208]
["01727",66,45,57,53,57,59,51,56,59,67,66,71,707,706]
["01728",53,37,45,44,45,49,50,48,54,56,61,55,597,598]
["01729",127,80,100,72,74,82,83,112,113,135,136,135,1249,1247]
["01730",102,66,78,62,64,57,51,64,81,91,96,100,912,912]
["01732",79,52,61,55,56,55,52,57,72,76,80,80,775,773]
["01733",46,36,45,47,50,49,46,53,44,44,51,50,561,558]
["01736",149,116,111,73,74,73,69,86,95,127,143,152,1268,1266]
["01737",82,53,65,58,62,58,53,62,73,79,81,85,811,812]
["01738",114,79,86,53,71,64,65,80,95,100,103,100,1010,1011]
["01740",56,39,50,48,51,54,55,67,55,55,63,57,650,650]
["01743",56,42,48,45,52,48,50,55,60,53,61,63,633,632]
["01744",77,54,65,56,59,67,65,83,84,93,90,85,878,877]
["01745",76,57,63,50,55,54,50,62,71,84,94,88,804,803]
["01746",72,56,63,58,64,57,54,68,66,65,71,80,774,773]
["01747",87,66,69,50,60,53,50,65,70,79,81,93,823,822]
["01748",90,66,76,63,64,60,62,77,69,78,89,87,881,881]
["01749",103,77,85,64,73,72,72,86,90,90,100,109,1021,1020]
["01750",105,73,83,55,73,65,75,89,91,101,100,105,1015,1015]
["01751",70,51,63,50,59,57,60,68,66,68,71,75,758,755]
["01752",124,98,93,62,64,60,58,72,81,102,107,127,1048,1047]
["01753",63,43,56,49,57,56,48,58,61,64,65,66,686,685]
["01754",56,42,52,48,52,56,50,61,49,52,63,60,641,638]
["01756",130,87,106,78,80,84,87,116,117,130,129,138,1282,1280]
["01757",56,42,51,48,53,53,54,66,56,54,58,59,650,648]
["01758",96,69,76,62,60,56,56,78,86,107,120,116,982,982]
["01759",56,42,52,47,53,53,55,65,54,54,59,60,650,649]
["01760",58,41,50,49,52,56,55,57,53,58,69,61,659,658]
["01761",115,83,94,71,78,74,74,91,98,97,109,120,1104,1101]
["01763",45,31,41,43,46,47,46,52,45,47,50,49,542,541]
["01764",166,119,131,74,96,84,88,110,143,150,154,152,1467,1466]
["01765",93,71,77,66,63,59,60,77,73,81,88,91,899,899]
["01766",171,115,137,105,98,111,123,138,150,185,195,201,1729,1725]
["01767",44,32,42,44,45,48,42,52,45,48,49,49,540,538]
["017682",96,60,68,47,59,60,64,78,85,97,96,92,902,901]
["017683",96,60,68,47,59,60,64,78,85,97,96,92,902,901]
["017684",96,60,68,47,59,60,64,78,85,97,96,92,902,901]
["017686",96,60,68,47,59,60,64,78,85,97,96,92,902,901]
["017687",96,60,68,47,59,60,64,78,85,97,96,92,902,901]
["017688",96,60,68,47,59,60,64,78,85,97,96,92,902,901]
["01769",126,88,88,65,67,66,66,83,88,110,119,127,1093,1090]
["01770",144,90,109,71,70,78,91,110,142,153,144,135,1337,1337]
["01771",80,53,64,51,57,56,65,79,77,79,86,79,826,825]
["01772",82,55,67,54,57,67,63,84,89,99,94,90,901,900]
["01773",74,59,63,57,59,65,59,67,66,69,73,79,{"$f":"SUM(B452:M452)","v":790},789]
["01775",48,37,46,48,52,51,48,58,47,44,54,51,584,582]
["01776",136,85,103,71,69,73,78,105,130,145,135,130,1260,1259]
["01777",50,41,49,51,51,54,49,55,47,46,53,55,601,598]
["01778",46,36,45,48,52,49,47,56,44,43,51,49,566,564]
["01779",74,49,57,46,53,49,61,70,71,75,78,72,755,754]
["01780",52,40,49,51,50,50,48,60,48,49,54,56,607,607]
["01782",77,57,67,62,68,69,64,80,75,76,83,84,862,861]
["01784",56,37,50,45,53,51,45,54,55,60,59,61,626,625]
["01785",62,47,54,52,61,58,53,65,62,59,66,69,708,709]
["01786",163,109,129,70,85,77,75,104,140,151,154,150,1407,1405]
["01787",48,33,43,43,43,47,46,48,48,49,56,52,556,554]
["01788",55,43,51,47,54,58,51,68,51,53,55,64,650,649]
["01789",51,39,48,44,51,55,50,64,52,47,52,59,612,612]
["01790",56,43,53,49,53,56,50,62,50,52,62,60,646,644]
["01792",129,87,91,68,73,75,73,96,110,129,134,137,1202,1201]
["01793",69,51,61,49,58,57,49,61,63,65,66,77,726,725]
["01794",90,63,70,51,63,58,46,64,71,81,85,95,837,836]
["01795",60,39,50,49,46,47,47,49,59,63,66,61,636,634]
["01796",132,83,97,51,71,67,75,88,104,121,110,123,1122,1123]
["01797",82,54,63,52,49,51,46,50,67,86,92,80,772,771]
["01798",103,67,79,64,63,60,52,66,82,93,99,102,930,928]
["01799",52,37,47,46,47,48,53,55,51,53,57,57,603,602]
["01803",145,115,106,71,73,70,67,85,91,111,124,142,1200,1199]
["01805",131,88,92,67,68,75,79,90,100,118,130,135,1173,1173]
["01807",83,56,75,61,71,74,83,96,93,100,96,87,975,973]
["01808",124,86,106,69,82,83,94,109,117,128,131,127,1256,1255]
["01809",269,187,246,118,125,125,138,165,242,286,283,293,2477,2478]
["01821",86,58,65,45,59,59,61,71,79,79,76,79,817,815]
["01822",148,107,102,71,78,72,78,91,96,123,130,145,1241,1242]
["01823",104,79,77,57,59,52,53,59,69,84,85,101,879,878]
["01824",128,89,98,76,75,70,69,90,106,119,136,142,1198,1196]
["01825",94,60,68,57,56,62,51,63,76,94,99,93,873,871]
["01827",58,46,50,50,55,55,48,63,54,53,57,64,653,653]
["01828",72,50,56,41,59,58,64,75,75,70,64,66,750,748]
["01829",64,49,55,52,63,61,56,66,65,69,78,74,752,750]
["01830",107,79,93,62,68,70,75,94,92,97,109,111,1057,1056]
["01832",51,39,47,49,49,51,47,55,46,47,53,55,589,587]
["01833",72,54,60,54,57,55,57,73,60,64,69,70,745,743]
["01834",110,81,84,63,61,59,51,81,90,121,117,120,1038,1037]
["01835",74,52,60,48,64,57,68,76,66,72,74,73,784,783]
["01837",164,114,114,78,82,80,87,100,103,132,142,154,1350,1350]
["01838",294,195,239,127,137,153,173,208,278,295,274,290,2663,2662]
["01840",150,97,107,74,73,85,89,99,107,131,148,148,1308,1306]
["01841",112,78,82,55,56,59,59,74,81,100,111,111,978,978]
["01842",51,36,47,44,52,56,51,55,50,53,59,55,609,611]
["01843",57,39,47,46,42,49,48,47,60,70,76,58,639,639]
["01844",56,39,50,45,54,56,49,62,56,57,56,63,643,640]
["01845",61,45,49,48,50,56,55,68,55,56,58,60,661,659]
["018476",96,67,75,54,52,57,59,78,91,94,116,103,942,941]
["018478",96,67,75,54,52,57,59,78,91,94,116,103,942,941]
["01848",136,92,100,67,80,69,71,97,123,135,126,130,1226,1223]
["01851",130,92,110,69,64,67,79,90,129,145,141,135,1251,1251]
["01852",180,111,144,81,84,92,118,132,188,206,184,180,1700,1700]
["01854",149,109,136,79,78,92,95,118,160,180,181,175,1552,1548]
["01855",327,221,281,149,150,170,206,238,329,351,319,344,3085,3083]
["01856",107,74,85,58,50,53,58,78,101,112,123,114,1013,1011]
["01857",110,74,89,58,48,52,56,77,105,120,127,119,1035,1034]
["01858",57,45,53,52,54,58,52,67,53,55,58,63,667,666]
["01859",170,113,144,91,91,104,134,146,181,187,181,180,1722,1722]
["01862",63,46,54,42,53,51,51,66,61,67,74,62,690,687]
["01863",143,100,124,76,75,72,67,83,113,144,161,151,1309,1305]
["01864",170,106,127,77,94,84,94,118,143,159,147,150,1469,1469]
["01865",58,42,53,46,56,56,45,56,54,56,56,65,643,642]
["01866",260,170,215,111,113,127,154,183,248,275,255,268,{"$f":"SUM(B516:M516)","v":2379},2379]
["01869",61,45,56,46,57,57,48,57,55,57,57,67,663,662]
["01870",142,93,112,61,63,69,82,92,130,149,142,136,1271,1271]
["01872",141,105,100,64,63,64,60,73,87,114,129,139,1139,1140]
["01873",161,112,113,83,88,72,63,88,114,131,135,160,1320,1320]
["01874",175,121,121,88,91,76,66,92,116,143,154,185,1428,1428]
["01875",52,36,46,38,50,48,56,63,61,61,55,48,614,612]
["01876",158,104,124,78,76,84,104,116,150,165,157,160,1476,1474]
["01877",209,144,171,91,111,104,111,144,196,210,194,202,1887,1885]
["01878",164,102,124,70,72,73,94,100,157,171,156,152,1435,1433]
["01879",132,83,101,62,61,64,81,98,134,146,127,126,1215,1213]
["01880",170,103,131,80,78,86,100,121,163,178,169,159,1538,1537]
["01882",180,120,144,70,93,82,90,108,137,162,146,164,1496,1497]
["01883",83,54,66,60,62,60,53,64,76,80,83,87,828,828]
["01884",101,78,72,55,62,56,54,64,69,84,83,99,877,876]
["01885",70,51,59,51,60,56,52,63,65,64,65,76,732,731]
["01886",63,47,52,46,56,51,45,55,56,55,56,68,650,649]
["01887",137,91,99,60,84,79,83,99,116,128,116,128,1220,1218]
["01888",82,53,65,56,60,58,66,79,75,81,87,78,840,840]
["01889",63,49,54,52,59,58,53,68,62,60,66,72,716,714]
["018902",55,39,47,43,49,52,57,64,56,58,58,52,630,630]
["018903",55,39,47,43,49,52,57,64,56,58,58,52,630,630]
["018907",55,39,47,43,49,52,57,64,56,58,58,52,630,630]
["018908",55,39,47,43,49,52,57,64,56,58,58,52,630,630]
["01892",87,58,65,55,56,60,51,61,75,88,91,87,834,833]
["01895",59,40,53,48,55,54,47,56,56,62,62,64,656,656]
["01896",97,69,77,54,70,61,69,83,84,89,86,91,930,929]
["01899",119,79,97,59,73,69,79,96,106,117,111,109,1114,1114]
["01900",90,59,79,56,59,72,80,96,112,127,98,97,1025,1025]
["01902",66,50,59,55,62,59,55,68,65,60,66,72,737,736]
["01903",75,50,61,51,49,49,42,55,61,80,83,78,734,736]
["01904",53,40,49,45,51,52,53,65,51,51,55,57,622,620]
["01905",62,48,51,44,55,52,45,56,57,54,56,67,647,646]
["01908",51,39,50,47,52,52,50,56,49,52,54,59,611,610]
["01909",60,50,55,56,56,59,54,59,56,55,63,65,688,686]
["0191",54,36,48,44,50,49,51,66,54,47,58,52,609,608]
["01920",59,42,51,49,50,55,50,54,54,59,60,63,646,647]
["01922",65,50,57,55,61,58,55,69,63,60,64,72,729,729]
["01923",67,46,59,52,58,59,50,60,60,67,68,72,718,716]
["01924",70,56,62,59,55,56,53,67,63,68,73,73,755,754]
["01925",67,49,56,55,60,63,60,74,71,76,79,73,783,782]
["01926",54,43,50,45,53,56,52,67,55,51,55,62,643,641]
["01928",65,49,55,54,62,63,59,70,66,72,78,72,765,763]
["01929",92,69,73,49,51,48,41,56,70,88,93,97,827,827]
["01931",171,114,120,71,84,74,76,104,123,157,160,172,1426,1424]
["01932",59,39,51,46,53,49,45,54,56,61,60,63,636,635]
["01933",49,40,48,48,52,55,48,58,48,49,53,58,606,605]
["01934",87,65,69,56,64,64,68,80,84,84,87,92,900,899]
["01935",96,71,72,49,62,54,52,66,71,79,80,98,850,849]
["01937",60,47,52,49,52,52,50,65,55,55,57,61,655,656]
["01938",108,80,84,64,71,62,59,77,86,90,104,115,1000,998]
["01939",61,46,53,47,55,51,55,60,63,59,68,70,688,686]
["01942",85,60,72,60,64,73,70,90,89,100,97,93,953,952]
["01943",97,73,81,71,68,67,60,80,83,89,95,100,964,961]
["01944",63,47,56,48,55,51,56,62,58,58,65,67,686,685]
["01945",47,34,45,44,51,51,51,57,47,45,54,51,577,577]
["01946",100,65,83,59,64,72,81,101,111,130,103,104,1073,1072]
["01947",68,49,57,52,56,54,55,69,58,65,78,73,734,732]
["01948",69,53,57,50,59,52,50,58,60,65,77,80,730,729]
["01949",51,45,47,48,49,55,49,59,49,49,53,57,611,610]
["01951",114,73,90,59,59,65,85,85,124,132,120,118,1124,1123]
["01952",60,45,53,51,59,55,52,63,63,56,63,67,687,687]
["01953",54,37,46,47,48,53,51,51,52,57,63,57,616,613]
["01954",44,33,42,44,48,50,44,54,46,47,50,49,551,551]
["01955",91,65,71,53,50,52,59,76,87,88,103,95,{"$f":"SUM(B580:M580)","v":890},889]
["01959",81,53,63,57,60,58,53,62,74,78,82,84,805,805]
["01962",89,62,70,51,59,57,47,61,73,80,84,93,826,824]
["01963",101,75,76,52,65,55,54,68,76,85,88,103,898,899]
["019645",58,43,54,52,55,53,52,67,55,56,66,68,679,677]
["019646",58,43,54,52,55,53,52,67,55,56,66,68,679,677]
["01967",304,205,258,142,147,157,181,221,305,339,299,316,2874,2873]
["01968",100,70,86,60,67,72,79,98,109,110,104,99,1054,1052]
["01969",186,126,148,102,102,103,110,142,161,178,183,193,1734,1734]
["01970",52,38,46,42,48,50,54,63,65,75,75,62,670,668]
["01971",141,94,125,75,64,80,86,105,151,161,172,151,1405,1404]
["01972",180,109,141,85,86,92,118,136,180,197,178,180,1682,1682]
["01974",117,76,84,70,73,72,79,95,107,123,123,127,1146,1144]
["019755",89,59,74,66,71,69,75,87,86,93,94,88,951,948]
["019756",89,59,74,66,71,69,75,87,86,93,94,88,951,948]
["01977",56,44,51,50,54,54,52,63,55,54,58,57,648,647]
["01978",110,80,85,71,76,65,61,78,88,102,113,122,1051,1051]
["01980",73,52,60,45,55,52,42,59,60,66,71,81,716,714]
["01981",123,84,90,71,74,58,51,75,84,92,102,110,1014,1013]
["01982",140,96,105,73,82,72,72,92,110,123,131,150,1246,1245]
["01983",89,61,67,54,53,51,45,61,74,88,93,87,823,821]
["01984",142,104,104,76,79,70,67,89,101,119,124,146,1221,1220]
["01985",94,71,77,57,66,61,58,75,77,83,89,101,909,909]
["01986",54,39,44,47,46,50,50,51,53,57,63,58,612,611]
["01988",119,78,90,67,64,72,74,104,116,127,114,112,1137,1136]
["01989",91,66,67,55,63,53,44,62,69,73,74,86,803,803]
["01992",59,42,52,50,53,55,51,55,56,60,61,64,658,658]
["01993",62,47,57,49,58,59,49,60,58,60,60,70,689,689]
["01994",147,102,108,82,80,78,71,104,118,155,147,155,1347,1348]
["01995",91,60,72,55,57,64,65,86,98,108,101,100,957,956]
["01997",123,89,105,60,69,66,63,76,96,118,134,132,1131,1130]
["020",56,37,49,46,52,51,46,54,54,60,59,60,624,623]
["02310",86,57,63,49,52,48,42,56,65,80,86,84,768,766]
["02311",86,57,63,49,52,48,42,56,65,80,86,84,768,766]
["02380",87,59,65,50,54,51,43,57,69,81,86,87,789,788]
["02392",84,56,63,49,52,47,42,58,66,80,85,83,765,762]
["024",59,49,52,50,55,61,52,70,56,55,59,66,684,682]
["029",103,76,82,59,67,70,71,85,95,100,104,106,1018,1016]

{"sheet":"Markers","index":14,"n_rows":111,"n_cols":19,"rows_kept":111,"cut":false,"hidden":false,"merged":[[5,15,6,15]]}
[]
[true,"Housing/feeding",{"$nulls":5},true,"Herringbone 1:1",null,"existing yes",true,null,"Men"]
[false,"Housing/feeding",{"$nulls":5},false,"Herringbone 1:2",null,null,"Herringbone 1:2",{"$nulls":4},"Loading",{"$f":"ROUNDUP('Options (2)'!$B$8/VALUE(LEFT(Markers!R8,2)),0)*VLOOKUP(VALUE(LEFT(Markers!R8,2)),loading,3)/60/60/24","v":"00:00:00"}]
[true,"Slurry",{"$nulls":5},false,"Rapid Exit",{"$nulls":8},{"$f":"R15*'Options (2)'!$B$8+R2","v":"00:00:00"}]
[{"$nulls":7},false,"Auto Tandem",{"$nulls":7},"Milking time",{"$f":"((IF(R6=1,R9,R9*0.6)/60/60/24)+R10+R11+R13+R14)*'Options (2)'!$B$8+R3","v":"00:00:00"}]
[{"$nulls":7},false,"Internal Rotary",{"$nulls":6},"Men","1:1 Herringbone",{"$f":"IF(VALUE(LEFT(R$8,2))>(VLOOKUP($Q6,manpower,2,FALSE)),2,1)","v":1}]
[false,"Straw yard",null,null,false,null,null,false,"External Rotary",{"$nulls":7},"1:2 Herringbone",{"$f":"IF(VALUE(LEFT(R$8,2))>(VLOOKUP($Q7,manpower,2,FALSE)),2,1)","v":1}]
[false,"Kennel",false,"Kennel 3 row",null,null,null,false,"AMS",{"$nulls":8},"16/16"]
[false,"Cubicles 2 Row",{"$nulls":4},"Exisiting","New",null,1,2,3,4,"Ex Times","New Times",null,"Cluster attach",{"$f":"+(12/60/60/24)","v":1.3888888888888889E-4}]
[true,"Cubicles 3 Row",{"$nulls":4},3,3,"Foremlik",6.9444444444444404E-5,3.4722222222222222E-5,0,null,{"$f":"HLOOKUP(G10,uddertime,MATCH(I10,$I$9:$I$15,0),0)","v":0},{"$f":"HLOOKUP(H10,uddertime,MATCH(I10,$I$9:$I$15,0),0)","v":0},null,"Automation time",{"$f":"$O$18+$O$21+$O$22","v":1.8518518518518518E-4}]
[false,"Slatted cubicles",false,"Slats 3 row",null,null,2,2,"Teat prep",1.7361111111111112E-4,9.2592592592592602E-5,9.2592592592592588E-5,0,9.2592592592592602E-5,9.2592592592592602E-5,null,"Udder routine",{"$f":"$O$16","v":1.6203703703703703E-4}]
[null,"Slurry system",{"$nulls":4},3,3,"Pre dip",5.7870370370370366E-5,2.3148148148148147E-5,0,null,0,0,null,"Loading"]
[{"$nulls":6},1,2,"Post Dip",5.7870370370370366E-5,2.3148148148148147E-5,0,0,5.7870370370370366E-5,2.3148148148148147E-5,null,"Unloading",{"$f":"6/60/60/24","v":6.9444444444444444E-5}]
[{"$nulls":6},1,4,"Cluster flush",1.1574074074074073E-4,2.3148148148148147E-5,0,0,1.1574074074074073E-4,0,null,"misctime",1.1574074074074073E-4]
[true,"Concrete",{"$nulls":4},4,4,"In parlour feeders",3.4722222222222222E-5,0,1.1574074074074073E-5,0,0,0]
[false,"Concrete + mat",{"$nulls":11},{"$f":"SUM(N10:N14,N19)","v":"00:00:27"},{"$f":"SUM(O10:O14,O19)","v":"00:00:14"},null,"Udder Routine time",{"$f":"SUM(R9:R14)","v":6.7129629629629625E-4}]
[false,"Concrete + mattress",{"$nulls":4},"Exisiting","New","Automation Cost",{"$f":"SUM(J18:J28)","v":0},true,false,null,"Ex Times","New Times"]
[false,"Concrete + water bed",{"$nulls":4},false,false,"Autoshedding",{"$f":"IF(AND(H18=TRUE,OR(VLOOKUP(TRUE,parlourtype,2,FALSE)=\"herringbone 1:1\",VLOOKUP(TRUE,parlourtype,2,FALSE)=\"herringbone 1:2\")),VLOOKUP(I18,equipcosts,2,FALSE),0)","v":0},0,3.4722222222222222E-5,null,{"$f":"HLOOKUP(G18,timings,MATCH(I18,$I$17:$I$27,0),0)","v":3.4722222222222222E-5},{"$f":"HLOOKUP(H18,timings,MATCH(I18,$I$17:$I$27,0),0)","v":3.4722222222222222E-5}]
[false,"Sawdust",{"$nulls":4},false,false,"ACRs",{"$f":"IF(H19=TRUE,VLOOKUP(I19,equipcosts,2,FALSE)*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourconfiguration,4,FALSE),0)","v":0},0,4.6296296296296294E-5,null,4.6296296296296294E-5,4.6296296296296294E-5]
[false,"Sand",{"$nulls":4},false,false,"In parlour feeders",{"$f":"IF(H20=TRUE,VLOOKUP(I20,equipcosts,2,FALSE)*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourconfiguration,5,FALSE),0)","v":0},null,null,null,{"$f":"N15","v":0},{"$f":"O15","v":0}]
[{"$nulls":6},false,false,"Auto ID",{"$f":"IF(H21=TRUE,(VLOOKUP(I21,equipcosts,2,FALSE)+(VLOOKUP(\"transponders\",equipcosts,2,FALSE)*herd)),\"\")","v":""},0,3.4722222222222222E-5,null,3.4722222222222222E-5,3.4722222222222222E-5]
[{"$nulls":6},false,false,"Backing Gate",{"$f":"IF(H22=TRUE,VLOOKUP(I22,equipcosts,2,FALSE),0)","v":0},0,1.1574074074074073E-4,null,1.1574074074074073E-4,1.1574074074074073E-4]
[{"$nulls":6},false,false,"Autowashing",{"$f":"IF(H23=TRUE,VLOOKUP(I23,equipcosts,2,FALSE),0)","v":0},0,0,null,0,0]
[true,"Autoscrapers",{"$nulls":4},false,false,"Electronic milk meters",{"$f":"IF(H24=TRUE,VLOOKUP(I24,equipcosts,2,FALSE)*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourconfiguration,4,FALSE),0)","v":0},null,null,null,0,0]
[false,"200 Lux lighting",{"$nulls":4},false,false,"Manual milk meters",{"$f":"IF(H25=TRUE,VLOOKUP(I25,equipcosts,2,FALSE)*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourconfiguration,4,FALSE),0)","v":0},null,null,null,{"$f":"HLOOKUP(G25,timings,MATCH(I25,$I$17:$I$27,0),0)","v":0},{"$f":"HLOOKUP(H25,timings,MATCH(I25,$I$17:$I$27,0),0)","v":0}]
[false,"Remote oestrus detection",{"$nulls":4},false,false,"Auto teat spray",{"$f":"IF(H26=TRUE,VLOOKUP(I26,equipcosts,2,FALSE),0)","v":0},null,null,null,{"$f":"HLOOKUP(G26,timings,MATCH(I26,$I$17:$I$27,0),0)","v":0},{"$f":"HLOOKUP(H26,timings,MATCH(I26,$I$17:$I$27,0),0)","v":0}]
[false,"High speed fan",{"$nulls":4},false,false,"Auto cluster flush",{"$f":"IF(H27=TRUE,VLOOKUP(I27,equipcosts,2,FALSE)*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourconfiguration,4,FALSE),0)","v":0},null,null,null,{"$f":"HLOOKUP(G27,timings,MATCH(I27,$I$17:$I$27,0),0)","v":0},{"$f":"HLOOKUP(H27,timings,MATCH(I27,$I$17:$I$27,0),0)","v":0}]
[true,"High volume low speed fan",{"$nulls":4},false,false,"Automatic dip & flush",{"$f":"IF(H28=TRUE,VLOOKUP(I28,equipcosts,2,FALSE)*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourconfiguration,4,FALSE),0)","v":0},0,0,null,{"$f":"HLOOKUP(G28,timings,MATCH(I28,$I$17:$I$28,0),0)","v":0},{"$f":"HLOOKUP(H28,timings,MATCH(I28,$I$17:$I$28,0),0)","v":0}]
[true,"Climate control - manual",{"$nulls":11},{"$f":"SUM(N18,N20:N22,N24)","v":"00:00:16"},{"$f":"SUM(O18,O20:O22,O24)","v":"00:00:16"}]
[false,"Climate control - auto",{"$nulls":11},"Loading times for herringbone & rapid exit"]
[false,"Flush washing",{"$nulls":11},0,0,0,null,null,1]
[{"$nulls":7},true,"All yr Calving",{"$nulls":4},1,10,{"$f":"SUM(load)","v":10},null,null,2]
[{"$nulls":13},2,9,{"$f":"SUM(load:O33)","v":19},null,null,3]
[2,"Bedding type",{"$nulls":11},3,8,{"$f":"SUM(load:O34)","v":27},null,null,4]
[false,"Manual Operation",{"$nulls":11},4,7,{"$f":"SUM(load:O35)","v":34}]
[true,"Chopper",{"$nulls":5},false,"Dairy building",{"$nulls":4},5,6,{"$f":"SUM(load:O36)","v":40}]
[false,"Spreader",{"$nulls":5},false,"Bulk tank",{"$nulls":4},6,5,{"$f":"SUM(load:O37)","v":45}]
[false,"Dispenser",{"$nulls":5},false,"Collecting yard",{"$nulls":4},7,4,{"$f":"SUM(load:O38)","v":49},null,"Herring List","Herring List1:2"]
[{"$nulls":7},false,"Handling/AI stalls",{"$nulls":4},8,3,{"$f":"SUM(load:O39)","v":52},null,8,8]
[{"$nulls":7},false,"Parlour building",{"$nulls":4},9,2,{"$f":"SUM(load:O40)","v":54},null,10,9]
[{"$nulls":13},10,1,{"$f":"SUM(load:O41)","v":55},null,12,10]
[{"$nulls":7},false,"Parlour equipment",{"$nulls":4},11,1,{"$f":"SUM(load:O42)","v":56},null,14,11]
["slurry",1,{"$nulls":5},false,"parlour automation",{"$nulls":4},12,1,{"$f":"SUM(load:O43)","v":57},null,16,12]
[{"$nulls":13},13,1,{"$f":"SUM(load:O44)","v":58},null,18,13]
[{"$nulls":13},14,1,{"$f":"SUM(load:O45)","v":59},null,20,14]
[{"$nulls":6},"Existing","operating costs","New","Ian's calc",null,null,null,15,1,{"$f":"SUM(load:O46)","v":60},null,22,15]
[{"$nulls":6},{"$f":"'Operating costs (3)'!B60*annuallitresex/100","v":0},"maintenance",{"$f":"'Operating costs (3)'!B60*annuallitres/100","v":0},14720,null,null,null,16,1,{"$f":"SUM(load:O47)","v":61},null,24,16]
[{"$nulls":6},{"$f":"(CIMex*365*2)*IF(Markers!$G$12=2,'Operating costs (3)'!$B$50,IF(Markers!$G$12=1,'Operating costs (3)'!$B$49,0))/100","v":0},"predip",{"$f":"(CIM*365*2)*IF(Markers!$H$12=2,'Operating costs (3)'!B50,IF(Markers!$H$12=1,'Operating costs (3)'!B49,0))/100","v":0},3392,null,null,null,17,1,{"$f":"SUM(load:O48)","v":62},null,26,17]
[{"$nulls":6},{"$f":"(CIMex*365*2)*IF(Markers!$G$13=3,'Operating costs (3)'!$B$53,IF(Markers!$G$13=2,'Operating costs (3)'!$B$52,IF(Markers!$G$13=1,'Operating costs (3)'!$B$51,0)))/100","v":0},"postdip",{"$f":"(CIM*365*2)*IF(AND(Markers!$H$13=3,Markers!$H$14=3),'Operating costs (3)'!$B$55,IF(Markers!$H$13=3,'Operating costs (3)'!$B$53,IF(Markers!$H$13=2,'Operating costs (3)'!$B$52,IF(Markers!$H$13=1,'Operating costs (3)'!$B$51,0))))/100","v":0},6817,null,null,null,18,1,{"$f":"SUM(load:O49)","v":63},null,28,18]
[{"$nulls":7},"cluster flush",{"$f":"(CIM*365*2)*IF(Markers!$H$14=3,'Operating costs (3)'!$B$54,IF(Markers!$H$14=1,'Operating costs (3)'!$B$48,IF(Markers!$H$14=2,'Operating costs (3)'!B48*0.3,0))/100)","v":0},{"$nulls":4},19,1,{"$f":"SUM(load:O50)","v":64},null,30,19]
[{"$nulls":6},{"$f":"(IF(Markers!$G$23=TRUE,60*'Options (2)'!E27,45*'Options (2)'!E27)+10*'Options (2)'!D27)*2*365*'Dairy Wizard'!$B$10/10^3","v":730},"water",{"$f":"(IF(Markers!$H$23=TRUE,60*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourdetails,5,FALSE),45*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourdetails,5,FALSE))+10*VLOOKUP(VLOOKUP(TRUE,parlourtype,2,FALSE),parlourdetails,4,FALSE))*2*365*'Dairy Wizard'!$B$10/10^3","v":803},4617,"25 litres/cow/day",null,null,20,1,{"$f":"SUM(load:O51)","v":65},null,32,20]
[{"$nulls":6},{"$f":"annuallitres*'Operating costs (3)'!$B$47*ElecCost/100","v":0},"electric",{"$f":"annuallitres*'Operating costs (3)'!$B$47*ElecCost/100","v":0},17480,"460*8000*0.05*9.5/100",null,null,21,2,{"$f":"SUM(load:O52)","v":67},null,34,21]
[{"$nulls":6},{"$f":"'Operating costs (3)'!$B$58*((CIMex*2*365)/'Operating costs (3)'!$B$59)","v":0},"liners",{"$f":"'Operating costs (3)'!$B$58*((CIM*2*365)/'Operating costs (3)'!$B$59)","v":0},2686,null,null,null,22,3,{"$f":"SUM(load:O53)","v":70},null,36,22]
[{"$nulls":6},{"$f":"(CIMex*365*2)*IF(OR(Markers!$G$11=2,Markers!$G$11=1),'Operating costs (3)'!$B$56,IF(Markers!$H$11=3,'Operating costs (3)'!$B$57,0))/100","v":0},"Wipes",{"$f":"(CIM*365*2)*IF(OR(Markers!$H$11=2,Markers!$H$11=1),'Operating costs (3)'!$B$56,IF(Markers!$H$11=3,'Operating costs (3)'!$B$57,0))/100","v":0},6145,null,null,null,23,4,{"$f":"SUM(load:O54)","v":74},null,38,23]
[{"$nulls":6},{"$f":"'Operating costs (3)'!$B$48*annuallitres/100","v":0},"cleaning",{"$f":"'Operating costs (3)'!B48*annuallitres/100","v":0},11040,"460*8000*0.3/100",null,null,24,5,{"$f":"SUM(load:O55)","v":79},null,40,24]
[{"$nulls":6},{"$f":"SUM(G47:G55)","v":730},null,{"$f":"SUM(I47:I55)","v":803},{"$f":"SUM(J47:J55)","v":66897},null,null,null,25,6,{"$f":"SUM(load:O56)","v":85},null,42,25]
[{"$nulls":13},26,7,{"$f":"SUM(load:O57)","v":92},null,44,26]
[{"$nulls":13},27,8,{"$f":"SUM(load:O58)","v":100},null,46,27]
[{"$nulls":13},28,8,{"$f":"SUM(load:O59)","v":108},null,48,28]
[{"$nulls":13},29,8,{"$f":"SUM(load:O60)","v":116},null,50,29]
[{"$nulls":13},30,8,{"$f":"SUM(load:O61)","v":124},null,52,30]
[{"$nulls":13},31,8,{"$f":"SUM(load:O62)","v":132},null,54,31]
[{"$nulls":13},32,8,{"$f":"SUM(load:O63)","v":140},null,56,32]
[{"$nulls":13},33,8,{"$f":"SUM(load:O64)","v":148},null,58,33]
[{"$nulls":13},34,8,{"$f":"SUM(load:O65)","v":156},null,60,34]
[{"$nulls":13},35,8,{"$f":"SUM(load:O66)","v":164},null,null,35]
[{"$nulls":13},36,8,{"$f":"SUM(load:O67)","v":172},null,null,36]
[{"$nulls":13},37,8,{"$f":"SUM(load:O68)","v":180},null,null,37]
[{"$nulls":13},38,8,{"$f":"SUM(load:O69)","v":188},null,null,38]
[{"$nulls":13},39,8,{"$f":"SUM(load:O70)","v":196},null,null,39]
[{"$nulls":13},40,8,{"$f":"SUM(load:O71)","v":204},null,null,40]
[{"$nulls":13},41,8,{"$f":"SUM(load:O72)","v":212},null,null,41]
[{"$nulls":13},42,8,{"$f":"SUM(load:O73)","v":220},null,null,42]
[{"$nulls":13},43,8,{"$f":"SUM(load:O74)","v":228},null,null,43]
[{"$nulls":13},44,8,{"$f":"SUM(load:O75)","v":236},null,null,44]
[{"$nulls":13},45,8,{"$f":"SUM(load:O76)","v":244},null,null,45]
[{"$nulls":13},46,8,{"$f":"SUM(load:O77)","v":252},null,null,46]
[{"$nulls":13},47,8,{"$f":"SUM(load:O78)","v":260},null,null,47]
[{"$nulls":13},48,8,{"$f":"SUM(load:O79)","v":268},null,null,48]
[{"$nulls":13},49,8,{"$f":"SUM(load:O80)","v":276},null,null,49]
[{"$nulls":13},50,8,{"$f":"SUM(load:O81)","v":284},null,null,50]
[{"$nulls":13},51,8,{"$f":"SUM(load:O82)","v":292},null,null,51]
[{"$nulls":13},52,8,{"$f":"SUM(load:O83)","v":300},null,null,52]
[{"$nulls":13},53,8,{"$f":"SUM(load:O84)","v":308},null,null,53]
[{"$nulls":13},54,8,{"$f":"SUM(load:O85)","v":316},null,null,54]
[{"$nulls":13},55,8,{"$f":"SUM(load:O86)","v":324},null,null,55]
[{"$nulls":13},56,8,{"$f":"SUM(load:O87)","v":332},null,null,56]
[{"$nulls":13},57,8,{"$f":"SUM(load:O88)","v":340},null,null,57]
[{"$nulls":13},58,8,{"$f":"SUM(load:O89)","v":348},null,null,58]
[{"$nulls":13},59,8,{"$f":"SUM(load:O90)","v":356},null,null,59]
[{"$nulls":13},60,8,{"$f":"SUM(load:O91)","v":364},null,null,60]
[{"$nulls":13},61,8,{"$f":"SUM(load:O92)","v":372}]
[{"$nulls":13},62,8,{"$f":"SUM(load:O93)","v":380}]
[{"$nulls":13},63,8,{"$f":"SUM(load:O94)","v":388}]
[{"$nulls":13},64,8,{"$f":"SUM(load:O95)","v":396}]
[{"$nulls":13},65,8,{"$f":"SUM(load:O96)","v":404}]
[{"$nulls":13},66,8,{"$f":"SUM(load:O97)","v":412}]
[{"$nulls":13},67,8,{"$f":"SUM(load:O98)","v":420}]
[{"$nulls":13},68,8,{"$f":"SUM(load:O99)","v":428}]
[{"$nulls":13},69,8,{"$f":"SUM(load:O100)","v":436}]
[{"$nulls":13},70,8,{"$f":"SUM(load:O101)","v":444}]
[{"$nulls":13},71,8,{"$f":"SUM(load:O102)","v":452}]
[{"$nulls":13},72,8,{"$f":"SUM(load:O103)","v":460}]
[{"$nulls":13},73,8,{"$f":"SUM(load:O104)","v":468}]
[{"$nulls":13},74,8,{"$f":"SUM(load:O105)","v":476}]
[{"$nulls":13},75,8,{"$f":"SUM(load:O106)","v":484}]
[{"$nulls":13},76,8,{"$f":"SUM(load:O107)","v":492}]
[{"$nulls":13},77,8,{"$f":"SUM(load:O108)","v":500}]
[{"$nulls":13},78,8,{"$f":"SUM(load:O109)","v":508}]
[{"$nulls":13},79,8,{"$f":"SUM(load:O110)","v":516}]
[{"$nulls":13},80,8,{"$f":"SUM(load:O111)","v":524}]

{"sheet":"Effect on profit","index":15,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Partial Budgets"]
[]
[]
["Cows",{"$f":"'Data entry (2)'!B4","v":100}]
["Option","Net capital invested £ total","Increased costs £/annum","Reduced costs £/annum","Effect on profit £/annum","% return on capital"]
["Cubicles v existing straw yard",{"$f":"'Cubicle v straw'!$D$23","v":64400},{"$f":"'Cubicle v straw'!G25","v":21206.666666666664},{"$f":"'Cubicle v straw'!N25","v":18260.333333333332},{"$f":"'Cubicle v straw'!G27","v":-2946.3333333333321},{"$f":"IF('Cubicle v straw'!G28<0,0,'Cubicle v straw'!G28)","v":4.2494824016563338E-3}]
["New cubicle v new straw yard",{"$f":"'New cubicle'!D23-'New cubicle'!K23","v":450},{"$f":"'New cubicle'!G25","v":27936.666666666664},{"$f":"'New cubicle'!N25","v":31385.333333333332},{"$f":"'New cubicle'!G27","v":3448.6666666666679},{"$f":"IF('New cubicle'!G28<0,0,'New cubicle'!G28)","v":7.6185775752973944E-2}]
["Mat + straw v concrete + straw",{"$f":"Mat!D21-Mat!K21","v":3000},{"$f":"Mat!G23","v":2850},{"$f":"Mat!N23","v":4000},{"$f":"Mat!G25","v":1150},{"$f":"IF(Mat!G26<0,0,Mat!G26)","v":0.43333333333333335}]
["Mattress + straw v concrete + straw",{"$f":"Mattress!D21-Mattress!K21","v":6000},{"$f":"Mattress!G23","v":3300},{"$f":"Mattress!N23","v":4000},{"$f":"Mattress!G25","v":700},{"$f":"IF(Mattress!G26<0,0,Mattress!G26)","v":0.16666666666666666}]
["Sand v concrete + straw",{"$f":"Sand!D21-Sand!K21","v":1000},{"$f":"Sand!G23","v":4850},{"$f":"Sand!N23","v":4550},{"$f":"Sand!G25","v":-300},{"$f":"IF(Sand!G26<0,0,Sand!G26)","v":0}]
["Autoscrapers v manual scraping",{"$f":"Scrapers!D21","v":6600},{"$f":"Scrapers!G23","v":1220},{"$f":"Scrapers!N23","v":5000},{"$f":"Scrapers!G25","v":3780},{"$f":"IF(Scrapers!G26<0,0,Scrapers!G26)","v":0.62272727272727268}]
["Flush washing v manual scraping",{"$f":"Flushing!D21-Flushing!K21","v":0},{"$f":"Flushing!G23","v":0},{"$f":"Flushing!N23","v":5000},{"$f":"Flushing!G25","v":5000},{"$f":"IF(Flushing!G26<0,0,Flushing!G26)","v":{"$error":"#DIV/0!"}}]
["Extra light",{"$f":"Light!D23","v":4500},{"$f":"Light!G25","v":8090},{"$f":"Light!N25","v":7414.4},{"$f":"Light!G27","v":-675.60000000000036},{"$f":"IF(Light!G28<0,0,Light!G28)","v":0}]
[]
["NOTES"]
["1. The results given will reflect the information you have entered at the data entry screen."]
["2. The summary shows that there is a wide range of the change in profit & the return on capital invested."]
["3. For mats & mattresses assumes depreciation over 5 years."]
["4. The benefit of mats, mattresses & sand excludes the potential benefit of reduced culling, lameness & mastitis."]
["5. For extra light the reduced costs include the benefit from higher milk yield"]
["6. Cubicle investment based on 2 row layout"]

{"sheet":"Data entry (2)","index":16,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["MDC dairy cow housing model"]
["Data entry"]
[]
["Cow number",{"$f":"'Data entry'!B6","v":100},"cows"]
["Annual yield/cow",{"$f":"'Data entry'!B7","v":7000},"litres"]
["Yield/cow/day",{"$f":"'Data entry'!B21","v":25},"litres"]
["Butterfat price",{"$f":"'Data entry'!B22","v":1.5},"p/1%"]
["Milk price",{"$f":"'Data entry'!B23","v":18.5},"p/litre"]
["Quota",{"$f":"'Data entry'!B25","v":0.1},"p/litre"]
["Milking diet cost",{"$f":"'Data entry'!B24","v":200},"p/cow/day"]
["Housing period",{"$f":"'Data entry'!B8","v":200},"days"]
["Depreciation buildings",{"$f":"'Data entry'!B10","v":5},"%"]
["Depreciation machinery",{"$f":"'Data entry'!B11","v":10},"%"]
["Interest",{"$f":"'Data entry'!B12","v":5},"%"]
["Water",{"$f":"'Data entry'!B14","v":1},"p/cubic metre"]
["Electricity",{"$f":"'Data entry'!B13","v":10},"p/kW hour"]
["Electricity off peak",2.6,"p/kW hour"]
["Labour",{"$f":"'Data entry'!B15","v":10},"£/hour"]
["Tractor + man",{"$f":"'Data entry'!B16","v":25},"£/hour"]
["Straw",{"$f":"'Data entry'!B17","v":40},"£/tonne"]
["Sand ",{"$f":"'Data entry'!B19","v":15},"£/tonne"]
["Sawdust",{"$f":"'Data entry'!B20","v":50},"£/tonne"]

{"sheet":"Operating costs (2)","index":17,"n_rows":88,"n_cols":7,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["MDC dairy cow housing model"]
["OPERATING COSTS"]
[]
["BEDDING REQUIREMENTS"]
[]
["Straw unchopped yard",{"$f":"'Operating costs'!B6","v":15},"kg/cow/day"]
["Straw unchopped cubicle",{"$f":"'Operating costs'!B8","v":7},"kg/cow/day"]
["Straw chopped cubicle",{"$f":"'Operating costs'!B9","v":5},"kg/cow/day"]
["Straw chopped cubicle/mat",{"$f":"'Operating costs'!B10","v":3},"kg/cow/day"]
["Sawdust cubicle",{"$f":"'Operating costs'!B11","v":1},"kg/cow/day"]
["Sand cubicle",{"$f":"'Operating costs'!B12","v":14},"kg/cow/day"]
[]
["LABOUR REQUIREMENTS"]
[]
["STRAW YARD bedding","Mins./cow/day","Labour units"]
["Manual bedding",{"$f":"'Operating costs'!B17","v":0.9},1]
["Tractor mounted",{"$f":"'Operating costs'!B18","v":0.45},1]
["Overhead dispenser",{"$f":"'Operating costs'!B19","v":0.3},1]
[]
["STRAW YARD cleaning","Mins./cow/day","Labour units","Note: 2 men; 1 tractor/1loader & 2 spreaders"]
["Yard cleaning",{"$f":"'Operating costs'!B22","v":0.28000000000000003},2,"Every 4 weeks, 48t straw & 108t slurry (60% of 60l/day) with 2 men"]
[]
["CUBICLE bedding","Mins./cow/day","Labour units"]
["Straw manual",{"$f":"'Operating costs'!B25","v":0.6},1]
["Straw tractor chopped",{"$f":"'Operating costs'!B26","v":0.5},1]
["Sawdust manual",{"$f":"'Operating costs'!B27","v":0.6},1]
["Sawdust dispenser",{"$f":"'Operating costs'!B28","v":0.3},1]
["Sand manual",{"$f":"'Operating costs'!B29","v":0.4},1,"3 times/week"]
["Sand dispenser",{"$f":"'Operating costs'!B30","v":0.13},1,"3 times/week"]
[]
["CUBICLE scraping","Mins./cow/day","Labour units"]
["Scraping",{"$f":"'Operating costs'!B33","v":0.6},1,"2 times/day. Storage adjacent to cubicles"]
[]
["Scraper system"]
["Maintenance £/cow/annum",{"$f":"'Operating costs'!B36","v":2}]
["Electricity kW/cow/day",{"$f":"'Operating costs'!B37","v":0.18}]
[]
["Flush system"]
["Maintenance £/cow/annum",{"$f":"'Operating costs'!B40","v":0}]
["Electricity kW/cow/day",{"$f":"'Operating costs'!B42","v":0}]
["Water use",{"$f":"'Operating costs'!B41","v":0},"cubic metres/cow/day (9cm/passage*20% daily change)"]
[]
["HS Ventilation system"]
["Maintenance % of capital",{"$f":"'Operating costs'!B45","v":2}]
["Electricity kW/cow/day",{"$f":"'Operating costs'!B46","v":1.6}]
["HVLS Ventilation system"]
["Maintenance % of capital",{"$f":"'Operating costs'!B48","v":2},"days"]
["Electricity kW/cow/day",{"$f":"'Operating costs'!B49","v":0.14000000000000001},"%"]
[]
["THI",null,"           Relative humidity %"]
["Temp",0,20,40,60,80,100]
[22,{"$nulls":5},72]
[24,null,null,null,72,73,75]
[26,null,null,72,74,77,79]
[28,null,72,74,78,82,84]
[30,null,74,77,80,83,86]
[32,72,76,79,83,86,90]
[34,74,78,82,86,90,94]
[36,76,80,85,90,94,98]
[38,78,83,87,92,97,99]
["Milk yield loss = 3%/1 THI (>73)"]
[]
["Supplemental light"]
["Yield increase",{"$f":"'Operating costs'!B66","v":8},"%"]
["Feed intake increase",{"$f":"'Operating costs'!B67","v":6},"%"]
["Decrease in BF%",{"$f":"'Operating costs'!B68","v":0.16},"%"]
["Electricity use Kw/cow/day",{"$f":"'Operating costs'!B69","v":2},null,"Milk yield loss = 3%/1 THI (>73)"]
[]
["Culling rate","%",null,"Cull cost","£/cow"]
["Straw",{"$f":"'Operating costs'!B77","v":28},null,"Heifer",{"$f":"'Operating costs'!E77","v":1750}]
["Concrete",{"$f":"'Operating costs'!B78","v":30},null,null,{"$f":"'Operating costs'!E78","v":0}]
["Mattress",{"$f":"'Operating costs'!B79","v":28},null,"Cull",{"$f":"'Operating costs'!E79","v":400}]
["Mat",{"$f":"'Operating costs'!B80","v":28},null,"Net",{"$f":"'Operating costs'!E80","v":1350}]
["Sand",{"$f":"'Operating costs'!B81","v":26}]
[]
["Lameness rate","%",null,"Lameness cost","£/cow"]
["Straw",{"$f":"'Operating costs'!B84","v":25},null,"Treatment cost",{"$f":"'Operating costs'!E84","v":246},"Esselmont & Kossabati, 1997"]
["Concrete",{"$f":"'Operating costs'!B85","v":28}]
["Mattress",{"$f":"'Operating costs'!B86","v":24}]
["Mat",{"$f":"'Operating costs'!B87","v":24}]
["Sand",{"$f":"'Operating costs'!B88","v":11}]
[]
["Mastitis rate","qtr/100 cows/yr",null,"Mastitis cost","£/cow/qtr"]
["Straw",{"$f":"'Operating costs'!B91","v":35},null,"Cost",{"$f":"'Operating costs'!E91","v":183},"Esselmont & Kossabati, 1997"]
["Concrete",{"$f":"'Operating costs'!B92","v":30}]
["Mattress",{"$f":"'Operating costs'!B93","v":25}]
["Mat",{"$f":"'Operating costs'!B94","v":25}]
["Sand",{"$f":"'Operating costs'!B95","v":20}]

{"sheet":"Capital costs (2)","index":18,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["MDC dairy cow housing model"]
[]
["CAPITAL COSTS"]
[]
["Housing only","Cost £/sq.metre","Sq.metre/cow","£/cow"]
["Straw yard",{"$f":"'Capital costs'!B6","v":125},{"$f":"'Capital costs'!C6","v":10.5},{"$f":"B6*C6","v":1312.5}]
["Kennel",{"$f":"'Capital costs'!B7","v":95},{"$f":"'Capital costs'!C7","v":4.5999999999999996},{"$f":"B7*C7","v":436.99999999999994},"Check - quote is £750/cow excluding concrete & electrics"]
["Cubicle excl. bed",{"$f":"'Capital costs'!B8","v":175},{"$f":"'Capital costs'!C8","v":4.5999999999999996},733,"£50 excluded for concrete bed - see below"]
["Cubicle with slats",{"$f":"'Capital costs'!B9","v":355},{"$f":"'Capital costs'!C9","v":4.5999999999999996},1292,"£50 added for division"]
[]
["Housing & feeding","Cost £/sq.metre","Sq.metre/cow","£/cow"]
["Straw yard",{"$f":"'Capital costs'!B15","v":104},{"$f":"'Capital costs'!C15","v":12.2},{"$f":"B12*C12","v":1268.8}]
["Kennel",{"$f":"'Capital costs'!B16","v":95},{"$f":"'Capital costs'!C16","v":8.9},{"$f":"B13*C13","v":845.5}]
["Cubicle",{"$f":"'Capital costs'!B17","v":126},{"$f":"'Capital costs'!C17","v":8.9},{"$f":"B14*C14","v":1121.4000000000001}]
["Cubicle with slats",{"$f":"'Capital costs'!B18","v":355},{"$f":"'Capital costs'!C18","v":8.9},{"$f":"B15*C15","v":3159.5}]
[]
["Slurry store",null,null,"£/cow","Based on 10 cubic metres/cow for 180 days"]
["Storage",{"$f":"'Capital costs'!B24","v":32},{"$f":"'Capital costs'!C24","v":15},{"$f":"B18*C18","v":480},"Based on 150 cow cost >1500 cubic metres"]
["Reception pit",null,null,{"$f":"'Capital costs'!D25","v":22},"Based on £3000 cost for 150 cows"]
["Pump",null,null,{"$f":"'Capital costs'!D26","v":27},"Based on £3000 cost for 150 cows"]
["TOTAL",null,null,{"$f":"SUM(D18:D20)","v":529}]
[]
["Scraper system",null,null,"£/cow"]
["Total installation",null,null,{"$f":"'Capital costs'!D30","v":66},"Based on quote for 200 cow unit, 4 passage of 40 metre length"]
[]
["Cubicle beds",null,null,"£/cow"]
["Cubicle division",null,null,{"$f":"'Capital costs'!D33","v":60},"Super comfort, high neck rail"]
["Concrete ",null,null,{"$f":"'Capital costs'!D34","v":55},"Division included in building cost for all options"]
["Mat + concrete",null,null,{"$f":"'Capital costs'!D35","v":85},"Mat £20 + £50 concrete"]
["Mattress + concrete",null,null,{"$f":"'Capital costs'!D36","v":115},"Mattress £45 + £50 concrete"]
["Sand & concrete",null,null,{"$f":"'Capital costs'!D37","v":65},"Initial filling of sand £12/cow, but offset by saving in concrete for bed"]
["Water beds",null,null,{"$f":"'Capital costs'!D38","v":165},"Bed £100 + £50 concrete"]
[]
["Ventilation",null,null,"£/cow"]
["High Speed Cooling fans",null,null,{"$f":"'Capital costs'!D41","v":150},"36 fans for 132 cows @ £200/fan"]
["High Volume Low Speed fan",null,null,{"$f":"'Capital costs'!D42","v":250},"6 fans for 132 cows @ £2700/fan"]
["Side wall curtain - auto",null,null,{"$f":"'Capital costs'!D43","v":55},"Based on 200 cows, 60m long building both sides. Includes climate control"]
["Side wall curtain - manual",null,null,{"$f":"'Capital costs'!D44","v":44},"Based on 200 cows, 60m long building both sides"]
["Insulated roof sheet",null,null,{"$f":"'Capital costs'!D45","v":0},"per sq.metre"]
[]
["Lighting",null,null,"£/cow"]
["Total installation",null,null,{"$f":"'Capital costs'!D48","v":45},"From Farm Energy Centre 2001."]
[]
["Flush washing",null,null,"£/cow"]
["Slurry separator",null,null,{"$f":"'Capital costs'!D51","v":0},"Based on quote of £30k for up to 650 cows with sand"]
["Flush system",null,null,{"$f":"'Capital costs'!D52","v":0},"Based on quote of £30k for 200 cows with 4 passages"]
["Storage tanks",null,null,{"$f":"'Capital costs'!D53","v":0}]
["TOTAL",null,null,{"$f":"SUM(D45:D47)","v":0}]
[]
["Machinery","£"]
["Straw spreader",{"$f":"'Capital costs'!B63","v":6600}]
["Straw overhead dispenser",{"$f":"'Capital costs'!B64","v":20000}]
["Straw chopper/tractor",{"$f":"'Capital costs'!B60","v":2750}]
["Sand dispenser",{"$f":"'Capital costs'!B61","v":3850}]
["Sawdust dispenser",{"$f":"'Capital costs'!B62","v":2200}]

{"sheet":"Cubicle v straw","index":19,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["MDC dairy cow housing model"]
[]
[]
[]
[]
[]
["LOSSES",{"$nulls":6},"GAINS"]
["Reduced Income",{"$nulls":5},"£/annum","Increased Income",{"$nulls":5},"£/annum"]
[]
[]
[]
["Increased Costs","Cows","Units","Days","Total","£/unit",null,"Cost Savings","Cows","Units","Days","Total","£/unit"]
["Straw",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B7","v":7},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(B13*C13*D13)/1000","v":140},{"$f":"'Data entry (2)'!B20","v":40},{"$f":"E13*F13","v":5600},"Straw",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B6","v":15},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I13*J13*K13)/1000","v":300},{"$f":"'Data entry (2)'!B20","v":40},{"$f":"L13*M13","v":12000}]
["Bedding",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B25","v":0.5},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(B14*C14*D14)/60","v":166.66666666666666},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"E14*F14","v":4166.6666666666661},"Bedding",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B17","v":0.45},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I14*J14*K14)/60","v":150},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"L14*M14","v":3750}]
["Slurry scraping",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B32","v":0.6},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(B15*C15*D15)/60","v":200},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"E15*F15","v":5000},"Yard cleaning",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B21","v":0.28000000000000003},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I15*J15*K15)/60","v":93.333333333333343},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"L15*M15","v":2333.3333333333335}]
[{"$nulls":7},"Mastitis",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B84-'Operating costs (2)'!B85","v":5},null,null,{"$f":"'Operating costs (2)'!E84","v":183},{"$f":"I16*J16/100*M16","v":915}]
[{"$nulls":7},"Lameness",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B77-'Operating costs (2)'!B78","v":-3},null,null,{"$f":"'Operating costs (2)'!E77","v":246},{"$f":"I17*J17/100*M17","v":-738}]
[]
["Capital","Cows","£/cow","£total","Int.£","Dep.£",null,"Capital","Cows","£/cow","£total","Int.£","Dep.£"]
["Cubicle building",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D28+'Capital costs (2)'!D27","v":115},{"$f":"B20*C20","v":11500},{"$f":"('Data entry (2)'!B14)*D20/100","v":575},{"$f":"('Data entry (2)'!B12)*D20/100","v":575},{"$f":"E20+F20","v":1150}]
["Slurry storage",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D21","v":529},{"$f":"B21*C21","v":52900},{"$f":"('Data entry (2)'!B14)*D21/100","v":2645},{"$f":"('Data entry (2)'!B12)*D21/100","v":2645},{"$f":"E21+F21","v":5290}]
["Straw chopper"]
["Total capital",null,null,{"$f":"SUM(D20:D22)","v":64400},null,null,null,"Total capital",null,null,{"$f":"SUM(K20:K22)","v":0}]
[]
["Total (A)",{"$nulls":5},{"$f":"SUM(G9:G24)","v":21206.666666666664},"Total (B)",{"$nulls":5},{"$f":"SUM(N9:N24)","v":18260.333333333332}]
[]
["Additional Profit (B-A) =",{"$nulls":5},{"$f":"N25-G25","v":-2946.3333333333321}]
["Return on capital invested %",{"$nulls":5},{"$f":"((G27+E20+E21)/D23)","v":4.2494824016563338E-3}]

{"sheet":"New cubicle","index":20,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["MDC dairy cow housing model"]
[]
[]
[]
[]
[]
["LOSSES",{"$nulls":6},"GAINS"]
["Reduced Income",{"$nulls":5},"£/annum","Increased Income",{"$nulls":5},"£/annum"]
[]
[]
[]
["Increased Costs","Cows","Units","Days","Total","£/unit",null,"Cost Savings","Cows","Units","Days","Total","£/unit"]
["Straw",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B7","v":7},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(B13*C13*D13)/1000","v":140},{"$f":"'Data entry (2)'!B20","v":40},{"$f":"E13*F13","v":5600},"Straw",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B6","v":15},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I13*J13*K13)/1000","v":300},{"$f":"'Data entry (2)'!B20","v":40},{"$f":"L13*M13","v":12000}]
["Bedding",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B25","v":0.5},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(B14*C14*D14)/60","v":166.66666666666666},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"E14*F14","v":4166.6666666666661},"Bedding",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B17","v":0.45},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I14*J14*K14)/60","v":150},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"L14*M14","v":3750}]
["Slurry scraping",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B32","v":0.6},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(B15*C15*D15)/60","v":200},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"E15*F15","v":5000},"Yard cleaning",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B21","v":0.28000000000000003},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I15*J15*K15)/60","v":93.333333333333343},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"L15*M15","v":2333.3333333333335}]
[{"$nulls":7},"Mastitis",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B84-'Operating costs (2)'!B85","v":5},null,null,{"$f":"'Operating costs (2)'!E84","v":183},{"$f":"I16*J16/100*M16","v":915}]
[{"$nulls":7},"Lameness",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B77-'Operating costs (2)'!B78","v":-3},null,null,{"$f":"'Operating costs (2)'!E77","v":246},{"$f":"I17*J17/100*M17","v":-738}]
[]
["Capital","Cows","£/cow","£total","Int.£","Dep.£",null,"Capital","Cows","£/cow","£total","Int.£","Dep.£"]
["Cubicle building",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D8+'Capital costs (2)'!D28","v":788},{"$f":"B20*C20","v":78800},{"$f":"('Data entry (2)'!B14)*D20/100","v":3940},{"$f":"('Data entry (2)'!B12)*D20/100","v":3940},{"$f":"E20+F20","v":7880},"Straw yard",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D6","v":1312.5},{"$f":"I20*J20","v":131250},{"$f":"('Data entry (2)'!B14)*K20/100","v":6562.5},{"$f":"('Data entry (2)'!B12)*K20/100","v":6562.5},{"$f":"L20+M20","v":13125}]
["Slurry storage",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D21","v":529},{"$f":"B21*C21","v":52900},{"$f":"('Data entry (2)'!B14)*D21/100","v":2645},{"$f":"('Data entry (2)'!B12)*D21/100","v":2645},{"$f":"E21+F21","v":5290}]
["Straw chopper"]
["Total capital",null,null,{"$f":"SUM(D20:D22)","v":131700},null,null,null,"Total capital",null,null,{"$f":"SUM(K20:K22)","v":131250}]
[]
["Total (A)",{"$nulls":5},{"$f":"SUM(G9:G24)","v":27936.666666666664},"Total (B)",{"$nulls":5},{"$f":"SUM(N9:N24)","v":31385.333333333332}]
[]
["Additional Profit (B-A) =",{"$nulls":5},{"$f":"N25-G25","v":3448.6666666666679}]
["Return on capital invested %",{"$nulls":5},{"$f":"((G27+E20+E21)/D23)","v":7.6185775752973944E-2}]

{"sheet":"Cubicle + slats","index":21,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["MDC dairy cow housing model"]
[]
[]
[]
[]
[]
["LOSSES",{"$nulls":6},"GAINS"]
["Reduced Income",{"$nulls":5},"£/annum","Increased Income",{"$nulls":5},"£/annum"]
[]
[]
[]
["Increased Costs","Cows","Units","Days","Total","£/unit",null,"Cost Savings","Cows","Units","Days","Total","£/unit"]
["Straw",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B7","v":7},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(B13*C13*D13)/1000","v":140},{"$f":"'Data entry (2)'!B20","v":40},{"$f":"E13*F13","v":5600},"Straw",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B6","v":15},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I13*J13*K13)/1000","v":300},{"$f":"'Data entry (2)'!B20","v":40},{"$f":"L13*M13","v":12000}]
["Bedding",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B25","v":0.5},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(B14*C14*D14)/60","v":166.66666666666666},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"E14*F14","v":4166.6666666666661},"Bedding",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B17","v":0.45},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I14*J14*K14)/60","v":150},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"L14*M14","v":3750}]
["Slurry scraping",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B32","v":0.6},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(B15*C15*D15)/60","v":200},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"E15*F15","v":5000},"Yard cleaning",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B21","v":0.28000000000000003},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I15*J15*K15)/60","v":93.333333333333343},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"L15*M15","v":2333.3333333333335}]
[{"$nulls":7},"Mastitis",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B84-'Operating costs (2)'!B85","v":5},null,null,{"$f":"'Operating costs (2)'!E84","v":183},{"$f":"I16*J16/100*M16","v":915}]
[{"$nulls":7},"Lameness",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B77-'Operating costs (2)'!B78","v":-3},null,null,{"$f":"'Operating costs (2)'!E77","v":246},{"$f":"I17*J17/100*M17","v":-738}]
[]
["Capital","Cows","£/cow","£total","Int.£","Dep.£",null,"Capital","Cows","£/cow","£total","Int.£","Dep.£"]
["Cubicle + slats",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D9+'Capital costs (2)'!D28","v":1347},{"$f":"B20*C20","v":134700},{"$f":"('Data entry (2)'!B14)*D20/100","v":6735},{"$f":"('Data entry (2)'!B12)*D20/100","v":6735},{"$f":"E20+F20","v":13470},"Straw yard",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D6","v":1312.5},{"$f":"I20*J20","v":131250},{"$f":"('Data entry (2)'!B14)*K20/100","v":6562.5},{"$f":"('Data entry (2)'!B12)*K20/100","v":6562.5},{"$f":"L20+M20","v":13125}]
["Slurry storage",{"$nulls":6},"Straw barn?"]
["Straw chopper"]
["Total capital",null,null,{"$f":"SUM(D20:D22)","v":134700},null,null,null,"Total capital",null,null,{"$f":"SUM(K20:K22)","v":131250}]
[]
["Total (A)",{"$nulls":5},{"$f":"SUM(G9:G24)","v":28236.666666666664},"Total (B)",{"$nulls":5},{"$f":"SUM(N9:N24)","v":31385.333333333332}]
[]
["Additional Profit (B-A) =",{"$nulls":5},{"$f":"N25-G25","v":3148.6666666666679}]
["Return on capital invested %",{"$nulls":5},{"$f":"((G27+E20+E21)/D23)","v":7.3375402128186107E-2}]

{"sheet":"Scrapers","index":22,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["MDC dairy cow housing model"]
[]
[]
[]
[]
[]
["LOSSES",{"$nulls":6},"GAINS"]
["Reduced Income",{"$nulls":5},"£/annum","Increased Income",{"$nulls":5},"£/annum"]
[]
[]
[]
["Increased Costs","Cows","Units","Days","Total","£/unit",null,"Cost Savings","Cows","Units","Days","Total","£/unit"]
["Scraper maint.",{"$f":"'Data entry (2)'!$B$4","v":100},null,null,null,{"$f":"'Operating costs (2)'!B35","v":2},{"$f":"B13*F13","v":200},"Slurry scraping",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B32","v":0.6},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I13*J13*K13)/60","v":200},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"L13*M13","v":5000}]
["Scraper elec.",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B36","v":0.18},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"B14*C14*D14","v":3600},{"$f":"'Data entry (2)'!B16","v":10},{"$f":"E14*F14/100","v":360}]
[]
[]
["Capital","Cows","£/cow","£total","Int.£","Dep.£",null,"Capital","Cows","£/cow","£total","Int.£","Dep.£"]
["Scraper system",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D24","v":66},{"$f":"B18*C18","v":6600},{"$f":"('Data entry (2)'!B14)*D18/100","v":330},{"$f":"('Data entry (2)'!B12)*D18/100","v":330},{"$f":"E18+F18","v":660}]
[]
[]
["Total capital",null,null,{"$f":"SUM(D18:D20)","v":6600}]
[]
["Total (A)",{"$nulls":5},{"$f":"SUM(G9:G22)","v":1220},"Total (B)",{"$nulls":5},{"$f":"SUM(N9:N22)","v":5000}]
[]
["Additional Profit (B-A) =",{"$nulls":5},{"$f":"N23-G23","v":3780}]
["Return on capital invested %",{"$nulls":5},{"$f":"(G25+E18)/D18","v":0.62272727272727268}]

{"sheet":"Flushing","index":23,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["MDC dairy cow housing model"]
[]
[]
[]
[]
[]
["LOSSES",{"$nulls":6},"GAINS"]
["Reduced Income",{"$nulls":5},"£/annum","Increased Income",{"$nulls":5},"£/annum"]
[]
[]
[]
["Increased Costs","Cows","Units","Days","Total","£/unit",null,"Cost Savings","Cows","Units","Days","Total","£/unit"]
["Flush maintenance",{"$f":"'Data entry (2)'!B4","v":100},null,null,null,{"$f":"'Operating costs (2)'!B39","v":0},{"$f":"B13*F13","v":0},"Slurry scraping",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B32","v":0.6},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I13*J13*K13)/60","v":200},{"$f":"'Data entry (2)'!B19","v":25},{"$f":"L13*M13","v":5000}]
["Flush elec.",{"$f":"'Data entry (2)'!B4","v":100},{"$f":"'Operating costs (2)'!B40","v":0},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"B14*C14*D14","v":0},{"$f":"'Data entry (2)'!B16/100","v":0.1},{"$f":"E14*F14","v":0}]
["Flush water",{"$f":"'Data entry (2)'!B4","v":100},{"$f":"'Operating costs (2)'!B41","v":0},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"B15*C15*D15","v":0},{"$f":"'Data entry (2)'!B15/100","v":0.01},{"$f":"E15*F15","v":0}]
[]
["Capital","Cows","£/cow","£total","Int.£","Dep.£",null,"Capital","Cows","£/cow","£total","Int.£","Dep.£"]
["Flush system",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D48","v":0},{"$f":"B18*C18","v":0},{"$f":"('Data entry (2)'!B14)*D18/100","v":0},{"$f":"('Data entry (2)'!B12)*D18/100","v":0},{"$f":"E18+F18","v":0}]
[]
[]
["Total capital",null,null,{"$f":"SUM(D18:D20)","v":0},null,null,null,"Total capital",null,null,{"$f":"SUM(K18:K20)","v":0}]
[]
["Total (A)",{"$nulls":5},{"$f":"SUM(G9:G22)","v":0},"Total (B)",{"$nulls":5},{"$f":"SUM(N9:N22)","v":5000}]
[]
["Additional Profit (B-A) =",{"$nulls":5},{"$f":"N23-G23","v":5000}]
["Return on capital invested %",{"$nulls":5},{"$f":"(G25+E18-L18)/(D21-K21)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Light","index":24,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["MDC dairy cow housing model"]
[]
[]
[]
[]
[]
["LOSSES",{"$nulls":6},"GAINS"]
["Reduced Income","Cows","Units","Days","Total","£/unit","£/annum","Increased Income","Cows","Units","Days","Total","£/unit","£/annum"]
["Butterfat ",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Data entry (2)'!B6","v":25},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"B9*C9*D9","v":500000},{"$f":"'Operating costs (2)'!B66*'Data entry (2)'!B7/100","v":2.3999999999999998E-3},{"$f":"E9*F9","v":1200},"Milk",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Data entry (2)'!B6*'Operating costs (2)'!B64/100","v":2},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"I9*J9*K9","v":40000},{"$f":"('Data entry (2)'!B8)/100","v":0.185},{"$f":"L9*M9","v":7400}]
[]
[]
["Increased Costs","Cows","Units","Days","Total","£/unit",null,"Cost Savings","Cows","Units","Days","Total","£/unit"]
["Quota",null,null,null,{"$f":"L9","v":40000},{"$f":"'Data entry (2)'!B9/100","v":1E-3},{"$f":"E13*F13","v":40},"Quota & BF%",null,null,null,{"$f":"E9*'Operating costs (2)'!B66*0.18","v":14400},{"$f":"'Data entry (2)'!B9/100","v":1E-3},{"$f":"L13*M13","v":14.4}]
["Feed",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B65","v":6},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"B14*C14/100*D14","v":1200},{"$f":"'Data entry (2)'!B10/100","v":2},{"$f":"E14*F14","v":2400}]
["Electricity",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B67","v":2},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"B15*C15*D15","v":40000},{"$f":"'Data entry (2)'!B16/100","v":0.1},{"$f":"E15*F15","v":4000}]
[]
[]
[]
["Capital","Cows","£/cow","£total","Int.£","Dep.£",null,"Capital","Cows","£/cow","£total","Int.£","Dep.£"]
["Lighting system",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D42","v":45},{"$f":"B20*C20","v":4500},{"$f":"D20*'Data entry (2)'!B14/100","v":225},{"$f":"D20*'Data entry (2)'!B12/100","v":225},{"$f":"E20+F20","v":450}]
[]
[]
["Total capital",null,null,{"$f":"SUM(D20:D22)","v":4500},null,null,null,"Total capital",null,null,{"$f":"SUM(K20:K22)","v":0}]
[]
["Total (A)",{"$nulls":5},{"$f":"SUM(G9:G24)","v":8090},"Total (B)",{"$nulls":5},{"$f":"SUM(N9:N24)","v":7414.4}]
[]
["Additional Profit (B-A) =",{"$nulls":5},{"$f":"N25-G25","v":-675.60000000000036}]
["Return on capital invested %",{"$nulls":5},{"$f":"(G27+E20)/D20","v":-0.10013333333333341}]

{"sheet":"Sand","index":25,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["MDC dairy cow housing model"]
[]
[]
[]
[]
[]
["LOSSES",{"$nulls":6},"GAINS"]
["Reduced Income",{"$nulls":5},"£/annum","Increased Income",{"$nulls":5},"£/annum"]
[]
[]
[]
["Increased Costs","Cows","Units","Days","Total","£/unit",null,"Cost Savings","Cows","Units","Days","Total","£/unit"]
["Sand",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B11","v":14},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"B13*C13*D13/1000","v":280},{"$f":"'Data entry (2)'!B21","v":15},{"$f":"E13*F13","v":4200},"Straw",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B8","v":5},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I13*J13*K13)/1000","v":100},{"$f":"'Data entry (2)'!B20","v":40},{"$f":"L13*M13","v":4000}]
[]
[]
[]
["Capital","Cows","£/cow","£total","Int.£","Dep.£",null,"Capital","Cows","£/cow","£total","Int.£","Dep.£"]
["Sand",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D31","v":65},{"$f":"B18*C18","v":6500},{"$f":"('Data entry (2)'!B14)*D18/100","v":325},{"$f":"('Data entry (2)'!B12)*D18/100","v":325},{"$f":"E18+F18","v":650},"Concrete",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D28","v":55},{"$f":"I18*J18","v":5500},{"$f":"K18*'Data entry (2)'!B14/100","v":275},{"$f":"K18*'Data entry (2)'!B12/100","v":275},{"$f":"L18+M18","v":550}]
[]
[]
["Total capital",null,null,{"$f":"SUM(D18:D20)","v":6500},null,null,null,"Total capital",null,null,{"$f":"SUM(K18:K20)","v":5500}]
[]
["Total (A)",{"$nulls":5},{"$f":"SUM(G9:G22)","v":4850},"Total (B)",{"$nulls":5},{"$f":"SUM(N9:N22)","v":4550}]
[]
["Additional Profit (B-A) =",{"$nulls":5},{"$f":"N23-G23","v":-300}]
["Return on capital invested %",{"$nulls":5},{"$f":"(G25+E18-L18)/(D21-K21)","v":-0.25}]

{"sheet":"Mattress","index":26,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["MDC dairy cow housing model"]
[]
[]
[]
[]
[]
["LOSSES",{"$nulls":6},"GAINS"]
["Reduced Income",{"$nulls":5},"£/annum","Increased Income",{"$nulls":5},"£/annum"]
[]
[]
[]
["Increased Costs","Cows","Units","Days","Total","£/unit",null,"Cost Savings","Cows","Units","Days","Total","£/unit"]
["Straw",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B9","v":3},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"B13*C13*D13/1000","v":60},{"$f":"'Data entry (2)'!B20","v":40},{"$f":"E13*F13","v":2400},"Straw",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B8","v":5},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I13*J13*K13)/1000","v":100},{"$f":"'Data entry (2)'!B20","v":40},{"$f":"L13*M13","v":4000}]
[]
[]
[]
["Capital","Cows","£/cow","£total","Int.£","Dep.£",null,"Capital","Cows","£/cow","£total","Int.£","Dep.£"]
["Mattress",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D30-'Capital costs (2)'!D28","v":60},{"$f":"B18*C18","v":6000},{"$f":"('Data entry (2)'!B14)*D18/100","v":300},{"$f":"('Data entry (2)'!B13)*D18/100","v":600},{"$f":"E18+F18","v":900}]
[]
[]
["Total capital",null,null,{"$f":"SUM(D18:D20)","v":6000},null,null,null,"Total capital",null,null,{"$f":"SUM(K18:K20)","v":0}]
[]
["Total (A)",{"$nulls":5},{"$f":"SUM(G9:G22)","v":3300},"Total (B)",{"$nulls":5},{"$f":"SUM(N9:N22)","v":4000}]
[]
["Additional Profit (B-A) =",{"$nulls":5},{"$f":"N23-G23","v":700}]
["Return on capital invested %",{"$nulls":5},{"$f":"(G25+E18-L18)/(D21-K21)","v":0.16666666666666666}]

{"sheet":"Mat","index":27,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["MDC dairy cow housing model"]
[]
[]
[]
[]
[]
["LOSSES",{"$nulls":6},"GAINS"]
["Reduced Income",{"$nulls":5},"£/annum","Increased Income",{"$nulls":5},"£/annum"]
[]
[]
[]
["Increased Costs","Cows","Units","Days","Total","£/unit",null,"Cost Savings","Cows","Units","Days","Total","£/unit"]
["Straw",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B9","v":3},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"B13*C13*D13/1000","v":60},{"$f":"'Data entry (2)'!B20","v":40},{"$f":"E13*F13","v":2400},"Straw",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Operating costs (2)'!B8","v":5},{"$f":"'Data entry (2)'!B11","v":200},{"$f":"(I13*J13*K13)/1000","v":100},{"$f":"'Data entry (2)'!B20","v":40},{"$f":"L13*M13","v":4000}]
[]
[]
[]
["Capital","Cows","£/cow","£total","Int.£","Dep.£",null,"Capital","Cows","£/cow","£total","Int.£","Dep.£"]
["Mat",{"$f":"'Data entry (2)'!$B$4","v":100},{"$f":"'Capital costs (2)'!D29-'Capital costs (2)'!D28","v":30},{"$f":"B18*C18","v":3000},{"$f":"('Data entry (2)'!B14)*D18/100","v":150},{"$f":"('Data entry (2)'!B13)*D18/100","v":300},{"$f":"E18+F18","v":450}]
[]
[]
["Total capital",null,null,{"$f":"SUM(D18:D20)","v":3000},null,null,null,"Total capital",null,null,{"$f":"SUM(K18:K20)","v":0}]
[]
["Total (A)",{"$nulls":5},{"$f":"SUM(G9:G22)","v":2850},"Total (B)",{"$nulls":5},{"$f":"SUM(N9:N22)","v":4000}]
[]
["Additional Profit (B-A) =",{"$nulls":5},{"$f":"N23-G23","v":1150}]
["Return on capital invested %",{"$nulls":5},{"$f":"(G25+E18-L18)/(D21-K21)","v":0.43333333333333335}]